[olug] Unix Tip: CONNECTING DATABASE THROUGH SHELl

[Unix Guru Universe]

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

			      UNIX GURU UNIVERSE 
			         UNIX HOT TIP

			Unix Tip 1919 - April  3, 2003

		    http://www.ugu.com/sui/ugu/show?tip.today

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


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 <login> -P <pass> -S <server> -D <database> -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 at wilco-int.com




--------------------------------------------------------------------------
To Subscribe:    http://www.ugu.com/sui/ugu/show?tip.subscribe
To Unsubscribe:  http://www.ugu.com/sui/ugu/show?tip.unsubscribe
To Submit A Tip: http://www.ugu.com/sui/ugu/show?tip.today

==========================================================================
DISCLAIMER: All UNIX HOT TIPS ARE OWNED BY THE UNIX GURU UNIVERSE AND ARE
NOT TO BE SOLD, PRINTED OR USED WITHOUT THE WRITTEN CONSENT OF THE UNIX 
GURU UNIVERSE. ALL TIPS ARE "USE AT YOUR OWN RISK". UGU  ADVISES THAT 
ALL TIPS BE TESTED IN A NON-PRODUCTION DEVELOPMENT ENVIRONMENT FIRST.

Unix Guru Universe - www.ugu.com - tips at ugu.com - Copyright 1994-2001
==========================================================================