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.
Finding option settings
Initial option settings
Deleting option settings
Alphabetical list of options