test/sql/Join/test016.ksh

   1 #!/bin/ksh
   2 # Testing LIKE operator in Join
   3 #create table emp(eno int,ename char(10),dno int);
   4 #create table dept(deptno int,dname char(10),lid int);
   5 #Insert some records into both the tables.
   6 #Test the following Select statements using join and BETWEEN operator and check the retrieved data are proper or not
   7 # select * from emp where emp.deptno in (20,30,40); here emp.deptno is non existing field.
   8 #
   9 QUITFILE=${PWD}/sql/Join/quit.sql
  10 REL_PATH=.
  11 if [ -s "$QUITFILE" ]
  12 then
  13  REL_PATH=`pwd`/sql/Join
  14 fi
  15
  16 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join34.sql
  17 if [ $? -ne 0 ]
  18 then
  19   exit 1;
  20 fi
  21 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_in_notexist.sql
  22 if [ $? -ne 0 ]
  23 then
  24   exit 1;
  25 fi
  26 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
  27 if [ $? -ne 0 ]
  28 then
  29   exit 1;
  30 fi