test/jdbc/Statement/test014.ksh

   1 #!/bin/sh
   2 # Getting maximum row information from select statement instance getMaxRows()
   3 # TestScript5.java
   4
   5 TESTFILE=${PWD}/jdbc/Statement/StmtTest1.java
   6 REL_PATH=.
   7 if [ -s "$TESTFILE" ]
   8 then
   9     REL_PATH=`pwd`/jdbc/Statement
  10 fi
  11 echo "Drop table T1;" > ${REL_PATH}/tmp.sql
  12 export CLASSPATH=$CLASSPATH:${REL_PATH}
  13 java TestScript5
  14 if [ $? -ne 0 ]
  15 then
  16 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/tmp.sql
  17 rm -f ${REL_PATH}/tmp.sql
  18    exit 1;
  19 fi
  20 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/tmp.sql
  21 rm -f ${REL_PATH}/tmp.sql
  22 exit 0;