Database Options

Database options and Interactive SQL options customize and modify database behavior. Sybase IQ database options are divided into three classes: general, Transact-SQL compatibility, and Interactive SQL.

• Introduction to Database Options
  Database options control many aspects of database behavior including compatibility, error handling, and concurrency.
• General Database Options
  General database options is the class of options consisting of all options except Transact-SQL compatibility options and Interactive SQL options.
• Transact-SQL Compatibility Options
  Transact-SQL compatibility options allow Sybase IQ behavior to be compatible with Adaptive Server Enterprise, or to both support old behavior and allow ISO SQL92 behavior.
• Interactive SQL Options
  Interactive SQL options change how Interactive SQL interacts with the database.
• Alphabetical List of Options
  Descriptions of general, Transact-SQL compatibility, and Interactive SQL database options. Some option names are followed by a class indicator in square brackets.