Shell Programming and Scripting

Msg 937, Level 14, State 1:
Server 'UAT_SRVR10':
Database 'test2' is unavailable. It is undergoing LOAD DATABASE.

Msg 4001, Level 11, State 1:
Server 'UAT_SRVR10':
Cannot open default database 'test2'.

Msg 208, Level 16, State 1:
Server 'UAT_SRVR10', Line 1:
TST_TABLE not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).

isql -U${dbuid} -P${dbpwd} -S${dbsrv} -w5000 << EOF >> outfile
select * from the testtable where testargs='zombie'
go
exit

EOF
if [[ $? != 0 ]]
then
echo "`date` Error has occured.  Database is not available !! >>logfile
echo "`date` ABORTING  ===================================" >>logfile
echo " kill my script if the above error generated !!!"
 exit  11
fi

echo " DB connection met and continue to do the rest of the script"

echo "$DB_PASSWD
select 'dAtA' as X, * from tablex . . . .
go' | isql -s'|' . . . 2>&1 | sed '
  s/^dAtA|//
  t d
  /^Password: $/d
  /^$/d
  /^|x   |/d
  /^|-[-|]*-|$/d
  b
  :d
  w '$data_file'
  d
 ' >>$log_file