#!/bin/sh
#
#  program name : test_opus_sql_gen
#  purpose : test opus_sql_gen
#  usage : $ test_opus_sql_gen
#
DSQUERY=ROBBIE
export DSQUERY
CDBS_DB=cdbs_dev
export CDBS_DB
#
echo " "
echo "loading opus_sql_gen test data ..."
echo " "
isql -SROBBIE -itest_wfpc.sql
#
echo " "
echo "test opus_sql_gen with argument <delivery_number> ..."
echo " "
echo "opus_sql_gen 102  # generate output file <opus_102_W.sql>"
opus_sql_gen 102
chmod +x opus_102_W.sql
#
echo " "
echo "test opus_sql_gen without argument, use default delivery number ..."
echo " "
echo "opus_sql_gen # generate output file <opus_104_W.sql>"
opus_sql_gen
chmod +x opus_104_W.sql
echo " "
#