Script page
Log command in history file
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.
Execution page
Automatically commit SQL statement
Stop execution if errors occur
Automatically commit SQL statement
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
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.
This option is not available for remote applets.
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 Script page of the Command Center notebook when the statement is executed.
The query results are shown on the Results page of the Command Center notebook. The access plan graph is shown on the Access Plan page.