Entering SQL commands

StepsTo enter SQL commands

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

  2. To send SQL commands to the server, enter a single SQL statement at the prompt, for example:

    select * from SYBASE.SAMPLETB
    

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

    begin
     select firstnme from sampletb
     select lastname from sampletb
    end
    

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.