Saving query results.

Use the Query Results page of the Command Center notebook to save the results of a query executed on the Interactive page or the Script page as text, as HTML, or as comma-separated variables.

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 save the results of a query:

1. Open the Command Center notebook.
2. View the results of a command script on the Query Results page.
3. Save the results as follows:
   1. To save the results as text select Query Results --> Save Data --> As Text.
   2. To save the results as HTML select Query Results --> Save Data --> As HTML.
   3. To save the results as comma-separated variables select Query Results --> Save Data --> As Comma-Separated Variables.
4. The Save As window will open and you can enter the name and location for the file you are saving.

Related information

• Command Center -- Overview
• Viewing the results of a query.
• 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