Script page
Log commands in history file
Number of commands in history lists
Log command in history file
When this check box is checked the results of commands executed will be recorded in a file. To 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.
This option is not available for remote applets.
Number of commands in history lists
Specify the number of commands to appear in the Command history lists that appear on the Interactive page and the Script page of the Command Center notebook.
Execution page
Automatically commit SQL statements
Stop execution if errors occur
Automatically commit SQL statements
When this check box is checked, every SQL statement that is executed in the Command Center will automatically be committed.
Stop execution if errors occur
When this check box is checked, execution of a sequence of SQL statements will be stopped at the statement where the error was found.
Results page
Verbose (echo command text to output)
Display SQLCA data
Display SQL statement warning messages
Display SQLCODE
Display SQLSTATE
Pipe output to file
Automatically display query results on the query
results page
Size of result fields
Verbose (echo command text to output)
When this check box is checked, the SQL statement being executed is displayed before its execution results.
Display SQLCA data
When this check box is checked, the SQLCA data will be displayed after each command execution result.
Display SQL statement warning messages
When this check box is checked, SQL statement warning messages will be displayed.
Display SQLCODE
When this check box is checked, the output from a command will contain the results of the command's execution followed by the SQLCODE.
Only one of Display SQLCODE and Display SQLSTATE may be selected at one time
Display SQLSTATE
When this check box is checked, the output from a command will contain the results of the command's execution followed by the SQLSTATE.
Only one of Display SQLCODE and Display SQLSTATE may be selected at one time
Pipe output to file
When this check box is checked the output from a command's execution will be recorded in a file. To specify the file where you want the results recorded, enter the path including the file name in the entry field below the Pipe output to file check box.
Automatically display query results on the query results page
When this check box is checked, the results of a select statement executed on the Interactive page of the Command Center notebook will be displayed on the Query Results page of the Command Center notebook.
Size of result fields
In this field, specify the size of the result fields in the Command Center notebook in kilobytes.
Access Plan page
Automatically generate access plan
Automatically generate access plan
Select the Automatically generate access plan check box if you want to automatically generate an access plan graph for any explainable statement entered on the Interactive page or Script page of the Command Center notebook when the statement is executed.
The query results are shown on the Query Results page of the Command Center notebook. The access plan graph is shown on the Access Plan page.