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:

1>

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:

quit

or:

exit

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.

Default Databases
When your SAP ASE account was created, you may have been assigned a default database to which you are automatically connected when you log in.
Network-Based Security Services with isql
Using network-based security services such as unified login allows you to authenticate with a security mechanism offered by a third-party provider and then log in to SAP ASE without specifying a login name or a password.

Parent topic: SQL Building Blocks