Changing the options in the Command Center notebook

Use the Command Center Options notebook to change the options in the Command Center notebook.

Fields and controls

Authorities and privileges

To view or change Command Center options:

1. Open the Command Center notebook.
2. Open the Command Center Options notebook.
3. Click the History tab. The History page opens.
   • Select or deselect the Log commands in history file check box.
   • Specify the file where you want the results recorded, enter the path including the file name in the entry field below the Log command in history file check box.
   • Specify the number of commands that you want to appear in the Number of commands in history lists field.
4. Click the Execution tab. The Execution page opens.
   • Select or deselect the Automatically commit SQL statement, or the Stop execution if errors occur check boxes.
5. Click the Results tab. The Results page opens.
   • Select or deselect the Verbose (echo command text to output), Display SQLCA data, Display SQL statement warning messages, Display SQLCODE, Display SQLSTATE, Pipe output to file, or Automatically display query results on the query results page options check boxes to enable the options that you want, or to disable the options that you do not want.
   • Specify the size of the result fields in the Size of result fields field.
6. Click the Access Plan tab. The Access Plan page opens.
   • Select or deselect the Automatically generate access plan check box.
7. When you are finished changing options on the Script page, click the OK push button on any options notebook page.

Related information

• Command Center -- Overview
• Executing commands in sequence
• Creating and saving a command script
• Running an existing command script on the Script page of the Command Center notebook
• Scheduling a job
• Creating an access plan