Database options control many aspects of database behavior. For example, you can use database options for the purposes such as the following:
Compatibility You can control how much like Adaptive Server Enterprise your IQ 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, using options.
