Database options control many aspects of database behavior. For example, you can use database options for the purposes such as:
Compatibility – lets you control how much like Adaptive Server Enterprise your Sybase IQ database operates, and whether SQL that does not conform to SQL92 generates errors.
Error handling – lets you control what happens when errors, such as dividing by zero or overflow errors, occur.
Concurrency and transactions – lets you control the degree of concurrency and details of COMMIT behavior using options.
