Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » Interactive SQL help » Options window: SQL Anywhere tab or Options window: UltraLite tab or Options window: SAP Sybase IQ tab or SAP HANA tab

 

Execution tab

The following options let you select when to commit changes to the database. You can also commit changes manually by entering an explicit COMMIT statement whenever appropriate.

  • Commit after every statement   Select this option to commit changes to the database after each SQL statement is executed.

  • Commit on exit or disconnect   Select this option to commit changes to the database when you exit your Interactive SQL session. This is the default.

  • Show progress messages   This option only applies to SQL Anywhere and SAP HANA databases and it is set by default. Select this option to display database progress messages in the Messages pane. Selecting this option is the same as setting the SQL Anywhere progress_messages database option to Formatted. When this option is not selected, it is the same as setting the progress_messages database option to Off.

 See also