ASA Database Administration Guide
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 Adaptive Server Anywhere database operates, and whether SQL that does not conform to SQL/92 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 options
Finding option settings
Scope and duration of database options
Setting public options
Deleting option settings
Option classification
Initial option settings