test/sql/Limit/test001.ksh

   1 #!/bin/ksh
   2 # Testing limit and offset
   3 # offset tells that from which record you want to fetch
   4 # limit tells that how many records you want to fetch from offset
   5 # offset 0 indicates the 1st record
   6 #
   7 CREATEFILE=${PWD}/sql/Limit/dropt1.sql
   8 REL_PATH=.
   9 if [ -s "$CREATEFILE" ]
  10 then
  11     REL_PATH=`pwd`/sql/Limit
  12 fi
  13
  14 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/limit1.sql
  15 if [ $? -ne 0 ]
  16 then
  17    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  18    exit 1;
  19 fi
  20
  21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  22 if [ $? -ne 0 ]
  23 then
  24    exit 3;
  25 fi
  26
  27 exit 0;