Result Sets

Work with the results of commands that you execute.

• Showing Multiple Results Sets (UNIX)
  By default, Interactive SQL shows the first result set of the most-recently executed statement. Use this procedure to see all result sets on UNIX platforms.
• Showing Multiple Result Sets (Windows)
  By default, Interactive SQL shows the first result set of the most-recently executed statement. Use this procedure to see all result sets on Windows platforms.
• Edit Result Sets in Interactive SQL
  Once you execute a query in Interactive SQL, you can sort and edit the result set to modify the database. You can also select rows from the result set and copy them for use in other applications.
• Generating SQL Statements from Result Sets
  You can create INSERT, DELETE, and UPDATE statements for selected rows in the result set.
• Printing SQL Statements and Result Sets
  You can print the contents of the SQL Statements pane or query results.