How can i Connect to a database via UNIX Shell Script

bharaniks · #1 (**permalink**) 11-06-07, 08:27

Hi,

Can any one please provide me a sample Shell Script which
Connects to a database and proceed with basic commands.

Thankyou.

stolze · #2 (**permalink**) 11-06-07, 11:54

Assuming you use DB2 as database system, it is really straight-forward:

Code:

#!/bin/sh

db2 "connect to dbname"
ls
db2 "select count(*) from syscat.tables"
mkdir abc
db2 "connect reset"

drogomoss · #3 (**permalink**) 12-10-07, 01:47

Hello there,

Script below done in AIX/RS6000/DB2

--------------------
#!/bin/ksh

#---- Set Environment
mdmdb="mydatabase"
mdmdbuser="myusername"
mdmdbpwd="mypassword"

#---- Connect to the Database
db2 connect to $mdmdb user $mdmdbuser using $mdmdbpwd

#
# Whatever you want to do goes here...
#

#---- Terminate DB2
db2 terminate

Hope this helps.

Merry Christmas.

J.Poornima · #4 (**permalink**) 12-18-07, 07:38

Assuming that you want to connect to Sybase

Method 1: Using Here Documents

isql -U<user name> -P<password> -S<server name> -o output.txt ............ << EOF
Whatever you want to do in the sybase
EOF

Method 2: using the input file parameter of isql

isql -U<username> -P<password> -S<server name> -i<input file> -o <output file>
where the input file will contain all what you want to do when the connection is established.

Regards,
Poornima