Viewing SQL Results

Use the SQL Results view to see the results of an executed SQL query or routine procedural object.

  1. Execute your SQL query, code to create a database object, or a routine procedural object.
  2. Examine the execution results in SQL Results view.
    • View the status of the query or object, the text of the query, the date and time, and error or informational messages.
    • Search result sets using standard Eclipse Find/Replace functionality.
    • Save a group (SQL statement, its children statements, and all their execution results) to a log file.
    • Display or save all SQL results in a file similar to iSQL command output.

    Note: The maximum number of result tabs that display is determined via the SQL Results view preference page. Any result sets that exceed the maximum number do not display. To view more result tabs, increase the limit. To view all results, export all results to a file and view the results in an external editor.
Related concepts
Run Overview
SQL Results View
SQL Results History
Related tasks
Creating a Launch Configuration for Routine Procedural Objects
Running a Stored Procedure
Running a Trigger
Running a User-Defined Function
Running a SQL Anywhere or Sybase IQ Event
Executing a SQL File
Removing Results from SQL Results View
Grouping SQL Results
Searching SQL Results
Terminating Execution in SQL Results View
Filtering SQL Results History
Saving a SQL Result History
Related reference
SQL Results View Options Preferences
Export Format Options Preferences
History Options Preferences


Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com