Viewing the results of a query.

Use the Query Results page of the Command Center notebook to view the results of a query executed on the Interactive page or the Script page.

When the Automatically commit updates check box is checked, the Commit Update button and the Rollback button will be disabled.

Fields and controls

Authorities and privileges

To view the results of a command script:

1. Open the Command Center notebook.
2. Execute a command script on the Interactive page or on the Script page.
3. Click the Query Results tab. The Query Results page opens.
4. If the Automatically commit updates check box is checked, the results of the most recently executed command script will be displayed on the Query Results page. If the Automatically commit updates check box is not checked, you can click the Commit Update button to commit the most recently executed command or script. The results of this command script will appear on the Query Results page.
5. If you wish to rollback to before the most recently committed command script was committed, click Rollback.
6. To have each command script committed automatically when it is executed. Check the Automatically commit updates check box.

Related information

• Command Center -- Overview
• Saving query results.
• Executing commands in sequence
• Creating and saving a command script
• Running an existing command script on the Script page of the Command Center notebook
• Executing single DB2 commands or SQL statements
• Running an existing command script on the Interactive page of the Command Center notebook
• Creating an access plan
• Changing the options in the Command Center notebook