The Query Options window enables you to specify options for your query.
The current query options override the application-level options.
You can select the following options:
Keep connection open between executions. Specify whether you want to keep the connection open and reuse it between script executions from this SQL Editor tab, rather than open a new connection for each execution.
You can also specify an application-level connection-handling setting.
Autocommit. Select this check box to have a transaction committed implicitly after each statement in a script is successfully completed. Clear the check box to explicitly commit or roll back a transaction (a user needs to manually insert COMMIT and ROLLBACK statements within the script).
By default, the Autocommit check box is selected. You can change the setting of the check box only if Keep connection open between executions is selected.
To open the Query Options window:
On the Query menu, click Current Query Options. You can also right-click in the Query Analyzer and select Options.