Controls the response to any SQL that is not part of the specified standard.
OFF
SQL:1992/Entry
SQL:1992/Intermediate
SQL:1992/Full
SQL:1999/Core
SQL:1999/Package
SQL:2003/Core
SQL:2003/Package
OFF
Flags as an error any SQL code that is not part of a specified standard as a warning. For example, specifying SQL:2003/Package causes the database server to flag syntax that is not full SQL/2003 syntax.
The default behavior, OFF, turns warning flagging off.
For compatibility with previous Sybase IQ versions, the values in Table 2-16 are also accepted, and are mapped as specified.
Value |
Action |
---|---|
E |
Flag syntax that is not entry-level SQL92 syntax. Corresponds to SQL:1992/Entry. |
I |
Flag syntax that is not intermediate-level SQL92 syntax. Corresponds to SQL:1992/Intermediate. |
F |
Flag syntax that is not full-SQL92 syntax. Corresponds to SQL:1992/Full. |
W |
Allow all supported syntax. Corresponds to OFF. |