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.
Created August 28, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com