isql utility

Use the standalone utility program isql to enter Transact-SQL statements directly from the operating system.

You must first set up an account, or login, on Adaptive Server. To use isql, type a command similar to the following at your operating system prompt:

isql -Uuser_name -Ppassword -Sserver_name

Once you are logged in, you see:

1>

NoteDo not use the -P option on the command line to access isql. Instead, to prevent another user seeing your password, wait for the isql password prompt.

Log out of isql by entering:

quit

or:

exit

See the Utility Guide.

To connect to a non-Sybase database using Component Integration Services, use the connect to command. See the Component Integration Services User’s Guide. See also connect to...disconnect in the Reference Manual: Commands.