test/sql/Join/test131.ksh

   1 #!/bin/ksh
   2 # Testing Join on 5 sales tables.
   3 # Create 5 tables like client_master,product_master,salesman_master,sales_order,sales_order_details.
   4 # populate the above tables with required values.
   5 # List the products which have been sold to 'Ivan Bayross'
   6 #
   7 QUITFILE=${PWD}/sql/Join/quit.sql
   8 REL_PATH=.
   9 if [ -s "$QUITFILE" ]
  10 then
  11     REL_PATH=`pwd`/sql/Join
  12 fi
  13
  14 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sales_tables.sql
  15 if [ $? -ne 0 ]
  16 then
  17    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sales_table_drop.sql
  18    exit 1;
  19 fi
  20
  21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sales_join.sql
  22 if [ $? -ne 0 ]
  23 then
  24    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sales_table_drop.sql
  25    exit 2;
  26 fi
  27
  28 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sales_table_drop.sql
  29 exit 0;