UDB 8.2, Solaris

Hi,

I've not done scripting and need to account for particular SQL codes coming back after db2 commands. Our current code is:

if [[ $rc -eq 0 ]]; then
echo "Deactivate database completed SUCCESSFULLY for $DBNAME on `date`." >> $
LOGFILE 2>&1
else
echo "\n!!! ERROR !!! -- deactivate db FAILED for database $DBNAME on `date`!
\n" >> $LOGFILE 2>&1
error_page
error_email
exit 4
fi

Can I say [ $rc -eq SQL1496W ] in an additional else clause or do I pull it some other way?

Thanks for your help,
brdholman

Nope. You'll have to parse the CLP output yourself.