Unix Tip #4367- February 24, 2014


SEARCH : Home : Help : Today's Tip

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.


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.


LAST 5 TIPS
4366 - SOLARIS CDE TOOL VERSIONS
4365 - REMOVING CONTROL CHARACTERS
4364 - GZIP ZNEW AND COMPRESS
4363 - QUICKLY FINDING SUN MEMORY
4362 - VALUE OF LAST PARAMETER


I want to SUBSCRIBE and get a UGU Tip everyday.
I want to UNSUBSCRIBE and NOT get a UGU Tip everyday.

If you have a UNIX TIP let us know, we just may use it:
(All tips become the property of the Unix Guru Universe)
Email Address:

Yes, email me a Hot Unix Tip everday.

Enter Hot Unix Tip (optional):

Yes, I will support this tip

Captcha (not case sensitive):


Please enter the above letters:


HOME | Flavors | Admin | Network | Security | S/W | Help | Events | Vendors | Careers | Internet
About | Add Link | Feedback | Search

Copyright © 1994-2005 Unix Guru Universe