Controls the behavior in response to any SQL code 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
Flags as an error any SQL code that is not part of a specified standard. For example, specifying SQL:2003/Package causes the database server to flag syntax that is not full SQL/2003 syntax.
For compatibility with previous Sybase IQ versions, the values in this table 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. |