Database options

Database options control many aspects of database behavior. For example, you can use database options for the following purposes:

  • Compatibility   You can control how much like Adaptive Server Enterprise your SQL Anywhere database operates, and whether SQL that does not conform to SQL/2008 generates errors. See Compatibility options.

  • Error handling   You can control what happens when errors such as divide by zero errors occur.

  • Concurrency and transactions   You can control the degree of concurrency, and details of COMMIT behavior.


Database options
Finding option settings
Initial option settings
Option setting deletion
Option classification
Alphabetical list of options