SQL_FLAGGER_ERROR_LEVEL Option [TSQL]

Controls the behavior in response to any SQL code that is not part of the specified standard.

Allowed Values

  • OFF

  • SQL:1992/Entry

  • SQL:1992/Intermediate

  • SQL:1992/Full

  • SQL:1999/Core

  • SQL:1999/Package

  • SQL:2003/Core

  • SQL:2003/Package

Default

OFF

Description

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.

SQL_FLAGGER_ERROR_LEVEL Compatibility Values

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.