test/jdbc/Statement/test024.ksh

   1 #!/bin/ksh
   2 TESTFILE=${PWD}/jdbc/Statement/StmtTest6.java
   3 REL_PATH=.
   4 if [ -s "$TESTFILE" ]
   5 then
   6     REL_PATH=`pwd`/jdbc/Statement
   7 fi
   8 export CLASSPATH=$CLASSPATH:${REL_PATH}
   9 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/ins.sql
  10 java AggPara
  11 if [ $? -ne 0 ]
  12 then
  13    echo "DROP TABLE T1;" >${REL_PATH}/dropT1.sql
  14    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/dropT1.sql
  15    rm -f ${REL_PATH}/dropT1.sql
  16    exit 1;
  17 fi
  18 exit 0;