Connect to a Remote Sybase Server Through Script

Shell Programming and Scripting
1

Hi all,
I am trying to connect to Remote Sybase database Server through shell script. I am operating on WindowsXP, connect to Unix(version SunOS: 5.8)
The thing is i dont know how to connect to Sybase Server through my script file?
Are there any manual pages which can guide me through the process???

Thanks In advance
Appu

2

Hi all,
Pls, can anyone guide me to find the man pages atleast. i dont know how to get connected to sybase through script.

would really appreciate for ur reply.

Appu.

3

Here is a Sybase FAQ that should help. This section talks about connecting to Sybase (ASE). You'll probably want to read more sections as well.

Incidently, isql is the utility that you'll probably use.

4

to connect to sybase you can use isql from your unix script, or odbc if you are programming in c o perl.
the isql syntax is like this:

#!/bin/ksh
DOWN()
{
isql -b -U$user -P$password -S$server -o$output <<END
go
go
sql statement
go
END
}

user=xxxxxx
password=yyyy
server=zzz
DOWN

anyway you can search for isql in this forum..
bye.