How to run script in Sybase

We can create scripts and execute using isql. This is useful when you need to execute the same set of commands.

Script execution Syntax:

isql -Uuser_name -Ppassword -Sserver_name -iscript_name -oscript_output

How to create scripts:
Create text file and paste the commands to be executed on SYBASE ASE.

root$vi databaseslist.txt

select name from sysdatabase
go
:wq!

Example:

root$ isql -Uuser_name -Ppassword -Sserver_name -idatabaseslist.txt -odatabaseslist.txt_output

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: