ISQL connectivity validation in script

view full story

http://www.unix.com – 1. Is there a way to validate ISQL connectivity in shell script(ksh) before executing any queries..? 2.what is the best way to handle NULL from ISQL restult assigned to a script variable ?(if ISQL connectivity fails) Code: rowCount=`/sybase/OCS-12_5/bin/isql -S $serverName -H $hostInfo -D $dbName -U $userName -P $passWord -b << EOF go set nocount on $query go EOF` 3. any specific configurations to be validated if the script is to be scheduled using cron ..? (HowTos)