Linux Tip of the Day - connecting database through shell
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.
Comments
Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!
-
RSS Feed
-
Subscribe via Email
