isql utility of Sybase can be
efficiently used through shell
scripts as follows:
---------------------------------------------------
#!/bin/sh
cat /dev/null>/tmp/qry.sql
cat << SQL >> /tmp/qry.sql
select name from sysobjects where type = 'T'
SQL
isql -U -P -S -D -i
/tmp/qry.sql
#remove the query file
rm /tmp/qry.sql
#end of script
------------------------------------------------------
Obviously you can use update/delete
queries of any complicacy in the
query.
This tip generously supported by: rsamik@wilco-int.com
NOTE: All tips provided are USE AT YOUR OWN RISK. Tips are submitted
by various unix admins around the globe. UGU suggest you read and
test each tip in a non-volitile environment before placing into
production.