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 SAP ASE. 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:
Note: 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:


For more information, see isql in the Utility Guide.

To connect to a non-SAP 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.