Using Transact-SQL in isql

isql sends Transact-SQL commands to the SAP ASE 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 the SAP ASE 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