sqlplus thru shellscript??

abhinavTCS · #1 (**permalink**) 04-04-06, 01:20

how do i execute sql queries thru shell scripts???

prashant_add · #2 (**permalink**) 04-04-06, 04:33

u can execute queries in sybase thru shell scripts as

open one file using vi editor as
vi filename
isql -Uuser_name -Ppassword -Sserver_name
sqlstatement.........
go
....................
go

save these statements in ur file

and then execute as

sh filename.sh

Quote:

Originally Posted by abhinavTCS

how do i execute sql queries thru shell scripts???

pdreyer · #3 (**permalink**) 04-04-06, 06:41

Something like this

Code:

#!/bin/ksh
id=$1
sqlplus -s user/passwd@remoteserver <<EOF
select * from client where id=$id;
EOF

Internet Services

Web Development

Digital Marketing

Consumer Tech