sql inside a script

Shell Programming and Scripting
1

Hi,

In a KSH script i have to run a sybase query and get the count into a unix variable.

How can i do that?

Your help is much appriciated.

Thanks,
sateesh

2

In ksh connect to sybase (it might differ with the version you use) generically it should be :

isql -U<LOGIN> -P<PASSWD> -S<SERVER> -w2000 << EOF > <LOGFILE>

----Your queries come here ------

EOF

The above format will let you execute the query in ksh script. Of coure if isql is not in your PATH you will have to give the whole PATH rather than just isql

Let me know if you need more help

3

Thanks for the reply,

But i want to run that command and take count assigned to a variable.

How can i do that

4

Check this post.

5

Hi can you tell me if there is a sybase sql client (iSQL) that works with SCO6 and if so where can I download it from?