How to use 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.

NoteTo 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