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

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


Commands 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 databases. 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 option to Off. This option is only available for SQL Anywhere databases. This option is set by default.

 See also