Hi,

I'm newbe with Sybase. I'm using ASE 12.5 and I want to create one DOS batch file in order to launch many Sybase commands automatically.

For example, execute some stored procedures then copy out tables by using bcp command.

Could someone help me please on hwo to write the batch file with isql commands?

Thanx in advance.

isql -Ulogin_name -Plogin_password -Sserver_name -i$SYBASE/@SYBASE-ASE/scripts/script_file

Thank you for the response.
But could you please share with me what will be the content of the script file?

Excuse me as it's new for me.

whatever you wanted to execute on sybase put them in that script file.

In my example, I've shown you how to execute one of the Sybase scripts files from the $SYBASE/@SYBASE-ASE/scripts folder. Open any file from that folder with a text editor and see what they've put there: SQL and T_SQL statements.
The idea is:
1. create such a script file, with your Sybase statements
2. create a .bat file with the isql statement like above that calls (with -i) your script file
3. run the .bat file

Hi,

I know that I have to put all commands I want to execute in the script file.
But my concern is about the content. Does it mean that I put only isql command inside it without DOS command?

Thx in advance.

Hi,

Does it mean that I have to put script file at $SYBASE/@SYBASE-ASE/scripts and then create .bat file to execute the commad you mentionned above?

Thx.

Excuse me, I'm back again, what is the meaning of $SYBASE/@SYBASE-ASE and what should be the exacte value of it?

Thx in advance.

These are environment variables that SYBASE needs.
You don't have to create the script files in that specific path, you may put them anywhere on your server.