Using Transact-SQL in isql

isql sends Transact-SQL commands to Adaptive Server, formatting the results and printing them to standard output.

There is no maximum size for an isql statement. For more information about using Transact-SQL, see the Transact-SQL User’s Guide.

Note: To use Transact-SQL directly from the operating system with the isql utility program, you must have an account, or login, on Adaptive Server.

To execute a Transact-SQL command, type the default command terminator “go” on a new line.

For example:

isql
Password:

1> use pubs2
2> go
1> select *
2> from authors
3> where city = "Oakland"
4> go

Formatting isql Output
The width for isql output is adjusted according to the character-set expansion or the character width, and displays a output column of the maximum possible bytes.
Correcting isql Input
You can correct input when you make an error when typing a Transact-SQL command.
set Options that Affect Output
A number of set options affect Transact-SQL output.

Parent topic: Using Interactive isql from the Command Line