The following table describes the menu bar located at the top
of the Query Design Center window.
Menu Item
Description
File
Enables you to connect to a resource for a server, disconnect
from a server, open an existing query, save a query, or save a query
result. You can also exit the Query Design Center Utility.
Query
The following commands are available:
Prepare
Validates the syntax of an SQL
statement and prepares the SQL statement for execution.
Execute
Executes the SQL statement.
Commit
Commits the current transaction
when the Manual Commit Mode command is set.
Abort
Aborts the current transaction when
the Manual Commit Mode command is set.
Savepoint
Creates a named savepoint when
the Manual Commit Mode option is set.
Rollback to Savepoint
Rolls back the current
transaction to a selected savepoint when the Manual Commit Mode command
is set.
View
Enables you to display the Resources window.
Options
The following commands are available:
QGraphs
Generates a QGraph which contains
information that is useful when you are manually optimizing queries.
QDumps
Generates a QDump which contains
diagnostic information used by Unisys support personnel to analyze
and troubleshoot problems you report to the Unisys Support Center.
Manual Commit Mode
Commits the results
of each SQL statement to the database. Manual commit mode is disabled
by default. You can enable Manual Commit Mode and then use the Commit
and Abort commands to manually manage transactions.
Isolation Level
Sets the transaction isolation
level.
Change Row Limit
Sets the number of rows
returned for queries.
Look and feel
Sets the look and feel of
the Query Design Center interface to the Windows, Metal (Java), or
Motif (UNIX) environment.
Windows
Enables you to switch between currently opened windows.
