Shell Programming and Scripting

test4@aceuatcs04:/u01/test4/SOLID/Testscript>cat TRUNCATE-PS_TXN.sh 
#--------------------------------------------------------------------
#  Created by:Kaushlesh Yadav
#  Generated on: 15/07/2010
#  Job name : TRUNCATE-PS_TXN Table in C & S 
#  Job description: Truncate Queries
# ----------------------------------------------------------------------
#
#
#!bin/bash
 
 
export ats_csd_table=`sqlplus -s $USER/$USER@$USER <<EOF
        set heading off feedback off verify off
        SELECT ATS_DATE||'|'||CSD_DATE||'|'||SYSTEM_STATUS FROM ATS_CSD_STATUS;
    exit
EOF
`
export p_date_event=`sqlplus -s $USER\cs/$USER\cs@$USER <<EOF
        set heading off feedback off verify off
        SELECT P_DATE||'|'||PARA_NUMBER FROM P_DATES D,P_NUMBERS N WHERE UPPER(D.DESCRIPTION) = UPPER('APPLICATION DATE') and UPPER(N.PARA_CODE) = UPPER('EVENT');      
        exit
EOF
`
export ats_status=`echo ${ats_csd_table}|cut -d '|' -f3`
export p_event=`echo ${p_date_event}|cut -d '|' -f2`
export Systemstate=''
export SPOOLFILE=$HOME/logs/PS_TXN.txt
if [ {${p_event} = '3500'} -a ${ats_status} = '7' ] ;then
     USERCS=$USER\cs
     CSPASS=$CS_DB_STRING
     echo "Now processing step: LOAD_"
     DB_CONNECT="$USERCS/$CSPASS@$USER"
     SPOOLFILE=$HOME/logs/PS_TXN.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 PS_TXN';
     End;
     /
     EOF
    exit                        
                
else   
     Systemstate='Exchange and Clearing systems are not in Sync'
         echo ${Systemstate}  >> ${SPOOLFILE}
fi
exit

./TRUNCATE-PS_TXN.sh 
then error: ./TRUNCATE-PS_TXN.sh: line 54: syntax error: unexpected end of file

#
#!bin/bash
 
 
export ats_csd_table=`sqlplus -s $USER/$USER@$USER <<EOF
        set heading off feedback off verify off
        SELECT ATS_DATE||'|'||CSD_DATE||'|'||SYSTEM_STATUS FROM ATS_CSD_STATUS;
    exit
EOF
`
+ sqlplus -s test4/test4@test4 
        set heading off feedback off verify off
        SELECT ATS_DATE||'|'||CSD_DATE||'|'||SYSTEM_STATUS FROM ATS_CSD_STATUS;
    exit
+ export ats_csd_table= 21/06/2010|21/06/2010|7 
TRUNCATE-PS_TXN.sh: ats_csd_table=: is not an identifier

#!/bin/bash

egrep "EOF" scriptname
export ats_csd_table=`sqlplus -s $USER/$USER@$USER <<EOF
EOF
export p_date_event=`sqlplus -s $USER\cs/$USER\cs@$USER <<EOF
EOF
     sqlplus -s ${DB_CONNECT} <<EOF
     EOF
export ats_csd_table=`sqlplus -s $USER/$USER@$USER <<EOF
EOF