UNIX for Dummies Questions & Answers

export SQL_QUERY="Select count(1) from SOME_TABLE where cur_pgm_name like 'DISPATCHER' and nxt_pgm_name like 'PM9USGLOADER' and file_status =
'AF' AND DATA_GROUP LIKE '%ASHISH%';"

export LOADER_AF_FILES_COUNT_NUM=`sqlplus -s user_name/password@db_instance << EOF
set echo off feed off heading off pagesize 0 trimspool on linesize 500
whenever sqlerror exit sql.sqlcode;
${SQL_QUERY}

EXIT;
EOF`

if [ $? -ne 0 ]
then
echo "Failed to execute query: ${SQL_QUERY}">> $LOG_FILE 2>&1
exit -10 ;
fi