|
Menu
|
Description
|
|
File
|
Commands to store and reuse the SQL expressions. The default folder for (*.sql) files is <infrastructure_administrator>\Data\SQLSheet\Scripts.
- Open—Opens an existing (*.sql) file and adds it to the Expression input box. You can edit the expression, and then execute it.
- Save—Saves the content of the expression input box.
- Save Output As—Saves the content of the Executed Script output box.
|
|
Edit
|
Commands to edit the content of the Expression input box and the Executed Script output box.
|
|
Execute
|
Commands to execute and commit the select statements.
- Execute At Cursor—Executes the select statement beginning at the cursor position. Use this command to execute part of a large SQL expression.
- Spool—Creates a spool file, by default named <infrastructure_administrator>\Data\SQLSheet\Log\Spool.log.
- History—Displays all select statements that were executed. To re-use, select the select statement, and click Copy To SQL Sheet.
|
|
Scripts
|
Starts SQL scripts stored in (*.sql) files. The menu shows all (*.sql) files stored under <infrastructure_administrator>\Data\SQLSheet\Scripts. Scripts in a subfolder appear in a submenu.
Copy your own SQL scripts to this location to make them available through this menu.
|
|
Tools
|
Commands to start tools.
- Gather Table Statistics—Update the record numbers that are displayed with the table names in the table list.
- Spool File—Opens the spool file.
- Log File—Opens the log file.
- Options—Auto-commit setting and import/export command parameters. For example, set EnableF4 to False to prevent the content of the input or output box being removed when you press [F4]. Set Show Amount Of Records Behind The Table to True to display the number of records in (USER_TABLES.NUM_ROWS).
|