Interactive page
Database connection
Command history
Command
SQLAssist
Append to Script
Results
Database connection
Select the database from the Select Database window by clicking:
. When a Database has been selected from the Select Database window it
will appear in this field.
Command history
Select a previously used command from the Command history. pull down. You can modify the number of commands shown in the Command history pull down from the History page of the Command Center Options notebook.
Command
This field contains the current command. It can be resized by dragging the horizontal bar between the Command field and the Results field.
You can use the Page Up and Page Down keys to recall commands from the command history. The command that is recalled will appear in the Command field.
SQLAssist
Click on this push button to open the SQL Assist notebook, in which you can get help in building SQL statements.
Append to Script
Select this push button to append the most recent command to the currently open script.
This button will be disabled if there are no commands in the command history and the Command field is empty.
Results
This field contains the results of running a script. It can be resized by dragging the horizontal bar between the Command field and the Results field.
Script page
Script History
Script
Results
Script History
Select a previously run script from this drop down box to run it again without typing it again.
Script
This field contains the current script. It can be resized by dragging the horizontal bar between the Script field and the Results field.
Results
This field contains the results of running a script. It can be resized by dragging the horizontal bar between the Script field and the Results field.
Query Results page
| Note: | This page will be blank unless you have selected Automatically display query results on the query results page in the Command Center Options notebook or until you execute a select query through the Retrieve Table Data icon. |
Automatically commit updates
Commit Update
Rollback
Automatically commit updates
Check the Automatically commit updates check box to have an update automatically committed each time you move to a new row in the table that you are working with.
Commit Update
Click the Commit Update push button to commit the update that you have just made.
The Commit Update push button will be disabled if the Automatically commit updates check box is checked.
Rollback
Click the Rollback push button to roll the table back to before the most recent change was committed.
The Rollback push button will be disabled if the Automatically commit updates check box is checked.
Access Plan page
| Note: | The Access Plan page will be blank if there is no Access Plan for the most recently issued command. |
Viewing a graphical representation of the Access Plan for an explained SQL statement.
Controls for the Command Center notebook
Execute
Retrieve Table Data
Access Plan
Execute
Click this icon to execute the command in the Command field on the Interactive page or the script in the Script field on the Script page.
Retrieve Table Data
Click this icon to execute the last statement that was executed on the Interactive page of the Command Center notebook as a select statement, and have it displayed on the Query Results page of the Command Center notebook.
When the Script page is selected, this button will be disabled.
When the Command page is selected, this button will be disabled if the last command executed did not generate table data.
Access Plan
click this icon to create an access plan for the last command issued.
When the Command page is selected, this button will be disabled if there is no access plan for the last command issued.