Establishing the connection  Viewing data results

Chapter 4: Using isql

Entering SQL commands

Use the Enter Open Client ISQL Commands panel to submit a SQL command to the specified server. The accessed DBMS must recognize these SQL commands.

To send SQL commands to the server, enter a single SQL statement at the prompt.

NoteTo get multiple results, type “begin,” then several lines without a joining semicolon, then type “end,” for example:

begin
 select firstnme from sampletb
 select lastname from sampletb
end

The following is a sample entry:

Figure 4-3: Enter Open Client ISQL Commands panel

When you press Enter, the server processes the SQL command and returns the results. If you turned tracing on or specified that results be saved to temporary storage, the server saves the results to temporary storage.





Copyright © 2005. Sybase Inc. All rights reserved. Viewing data results

View this book as PDF