test/jdbc/Parameters/test002.ksh

   1 #!/bin/ksh
   2 # select tuple with WHERE clause having param for some fields(SELECT * FROM T1 WHERE f1='now' AND f2=? AND f3=?)
   3 # Create a table having f1 date, f2 tnt and f3 string
   4 # Execute SELECT * FROM T1 WHERE f1='now' AND f2=? AND f3=?;
   5 TESTFILE=${PWD}/jdbc/Parameters/ParaTest2Now.java
   6 REL_PATH=.
   7 if [ -s "$TESTFILE" ]
   8 then
   9     REL_PATH=`pwd`/jdbc/Parameters
  10 fi
  11 export CLASSPATH=$CLASSPATH:${REL_PATH}
  12 java ParaTest2Now
  13 if [ $? -ne 0 ]
  14 then
  15    exit 1;
  16 fi
  17 exit 0;