test/sql/Join/test012.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 #create three tables as:
   4 #create table emp(eno int,mgrno int,sal float,deptno int);
   5 #create table dept(deptno int,dname char(10),lid int);
   6 #create table loc(lid int,state char(10));
   7 #Insert valid records into the 3 tables. Insert NULL values in some of the field
   8 #select * from emp,dept,loc where emp.deptno!=dept.deptno AND dept.lid!=loc.lid;
   9 #select * from emp,dept,loc where NOT(emp.deptno!=dept.deptno AND dept.lid!=loc.lid);
  10 #
  11 QUITFILE=${PWD}/sql/Join/quit.sql
  12 REL_PATH=.
  13 if [ -s "$QUITFILE" ]
  14 then
  15  REL_PATH=`pwd`/sql/Join
  16 fi
  17
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join31.sql
  20 if [ $? -ne 0 ]
  21 then
  22   exit 1;
  23 fi