You can use Transact-SQL directly from the operating system with the standalone utility program isql.
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 -Uhoratio -Ptallahassee -Shaze -w300
where:
“horatio” is the user
“tallahassee” is the password
“haze” is the name of the Adaptive Server to which you are connecting
The -w parameter displays isql output at a width of 300 characters. Login names and passwords are case-sensitive.
If you start isql without using a login name, Adaptive Server assumes that your login name is the same as your operating system name. For details about specifying your server login name and other parameters for isql, see the Utility Guide for your platform.
Do not use the -P option on the command
line to access isql. Instead, wait for the isql
password prompt, to avoid another user seeing your password.
After you start isql, you see:
1>
You can now start issuing Transact-SQL commands.
To connect to a non-Sybase database using Component Integration Services, use the connect to command. For more information, see the Component Integration Services User’s Guide. See also connect to...disconnect in the Reference Manual: Commands.
