Introduction to 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/2003 generates errors.

  • Error handling   You can control what happens when errors such as dividing by zero, or overflow errors, occur.

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


Setting database options
Finding option settings
Initial option settings
Deleting option settings
Option classification
Alphabetical list of options