Viewing IMS SQL Results

Use the SQL Results view to see the results of an executed SQL query.

  1. Execute your SQL query.
  2. Examine the execution results in SQL Results view.
    • View the status of the query, 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
IMS SQL Results View
Related tasks
Executing an IMS SQL Statement
Terminating Execution in IMS SQL Results View
Exporting IMS SQL Execution Results
Saving IMS SQL Execution Results to a Project
Removing Results from IMS SQL Results View
Saving IMS SQL Results History
Filtering IMS SQL Results History
Related reference
IMS SQL Results View Preferences
IMS SQL Results Export Format Preferences
IMS SQL Results History Preferences
IMS SQL Result Set Viewer Preferences