test/jdbc/Parameters/test001.ksh

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