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:


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