The following options let you select when to commit changes to the database. You can also commit 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. See auto_commit option [Interactive SQL].
Show progress messages This option only applies to SQL Anywhere databases.
Select this option to display SQL Anywhere database progress messages in the Messages pane. Selecting this option is the same as setting the SQL Anywhere database option progress_messages 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 is the default. See progress_messages option.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|