test/sqlnetwork/Jdbcnetwork/test026.ksh

   1 #!/bin/ksh
   2 # select tuple with WHERE clause having param for some fields(SELECT * FROM T1 WHERE f1=?AND f2=? AND f3=?)
   3 TESTFILE=${PWD}/sqlnetwork/Jdbcnetwork/StmtTest6.java
   4 REL_PATH=.
   5 if [ -s "$TESTFILE" ]
   6 then
   7     REL_PATH=`pwd`/sqlnetwork/Jdbcnetwork
   8 fi
   9 export CLASSPATH=$CLASSPATH:${REL_PATH}
  10 echo "SELECT * FROM T1 WHERE f1=?AND f2=? AND f3=?"
  11 java StmtTest6
  12 if [ $? -ne 0 ]
  13 then
  14    exit 1;
  15 fi
  16 exit 0;