Setting options for Transact-SQL compatibility

Set Sybase IQ database options using the SET OPTION statement. See “Transact-SQL compatibility options” in “Database Options,” Reference: Statements and Options, for a list of option settings required for compatible behavior.