test/sql/Join/test018.ksh

   1 #!/bin/ksh
   2
   3 #
   4 QUITFILE=${PWD}/sql/Join/quit.sql
   5 REL_PATH=.
   6 if [ -s "$QUITFILE" ]
   7 then
   8  REL_PATH=`pwd`/sql/Join
   9 fi
  10
  11 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join34.sql
  12 if [ $? -ne 0 ]
  13 then
  14   exit 1;
  15 fi
  16 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_like_notexist1.sql
  17 if [ $? -ne 0 ]
  18 then
  19   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
  20   exit 1;
  21 fi
  22 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_like_notexist2.sql
  23 if [ $? -ne 0 ]
  24 then
  25   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
  26   exit 1;
  27 fi
  28 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
  29 if [ $? -ne 0 ]
  30 then
  31   exit 1;
  32 fi