Shell Programming and Scripting

#!/bin/ksh
# ----------------------------------------------------------------------
#
#  Created by: XXXX
#  Generated on: 03/02/2009 15:00:00
#  Job name : TRUNC-MEMBER
#  Job description: Truncate Queries
# ----------------------------------------------------------------------
#
echo "Now processing step: LOAD_"
DB_CONNECT="USER/PASS@TESTDB"
SPOOLFILE=/home/log.txt

echo "Now processing step:" $DB_CONNECT
sqlplus -s ${DB_CONNECT} <<EOF

spool ${SPOOLFILE}

whenever oserror exit sql.sqlcode
whenever sqlerror exit sql.sqlcode
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED

declare
Begin

DBMS_OUTPUT.PUT_LINE('started;');
EXECUTE IMMEDIATE 'TRUNCATE TABLE MEMBER DROP STORAGE';

End;

spool off;
EXIT;
EOF
echo "Now processing step: LOAD_"

echo "Now processing step: LOAD_"
DB_CONNECT="OPS_STATS/OPS_4STATS@UTIDAL"
SPOOLFILE=/home/ca51336/log.txt

echo "Now processing step:" $DB_CONNECT
sqlplus -s ${DB_CONNECT} <<EOF

spool ${SPOOLFILE}

whenever oserror exit sql.sqlcode
whenever sqlerror exit sql.sqlcode
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED


TRUNCATE TABLE MEMBER DROP STORAGE;


spool off;
exit;
EOF
echo "Now processing step: LOAD_"

SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED
SET FEED OFF
spool ${SPOOLFILE}

BEGIN

DBMS_OUTPUT.PUT_LINE('started;');
EXECUTE IMMEDIATE 'TRUNCATE TABLE MEMBER DROP STORAGE';
END;
/
spool off;
exit;
EOF