Shell Programming and Scripting

echo "going to execute isql for getting JE count"
isql -Uxyz -SSYB_LOCOMOTIVE_xx -Pabc -Dlmn -w300 -o$sumOfJEOutputFile <<EOF
select sum(count(*)) from lmn..ex_je_t where clm_id in ($(cat $finalTemp)) group by clm_id
go
EOF
retval=$?
cat $retval
if [[ $retval != 0 ]]; then
                echo "Failed to connect to the Database" | mail -s "ERROR OCCURED:Database connection Failed" "$EXPRS_SUPPORT" 
                exit 0
else
                echo "Database connection successful."
fi
echo "coming out of isql command"
echo "#################################### output of isql command for getting the sum of JEs ##################################################"
cat $sumOfJEOutputFile

Msg 102, Level 15, State 1:
Server 'SYB_LOCOMOTIVE_JE', Line 1:
Incorrect syntax near ')'.

isql -Uxyz -SSYB_LOCOMOTIVE_xx -Pabc -Dlmn -w300 -o$sumOfJEOutputFile --retserverror

isql -Uxyz -SSYB_LOCOMOTIVE_xx -Pabc -Dlmn -w300 -o$sumOfJEOutputFile --retserverror <<EOF

--retserverror
Forces isql to terminate and return a failure code when it encounters a server error of severity greater than 10. 
When isql encounters this type of abnormal termination, it writes the label “Msg” together with the actual Adaptive Server error number to stderr, 
and returns a value of 2 to the calling program.
isql prints the full server error message to stdout.