|
|
|
|
UGU: Unix Guru Universe - Unix Tip #4367- February 24, 2024
- Home : Help
: Today's Tip
Unix Tip #4367- February 24, 2024
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)
|
|
| |
Copyright 1994-2024 Unix Guru Universe
|
|
|
|
|
Home
