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>
Do 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.