Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

sql_flagger_error_level option [compatibility]

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
• Ultralite

Off

This option flags as an error any SQL that is not part of the specified standard. 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 error flagging off.

For compatibility with previous SQL Anywhere versions, the following values are also accepted, and are mapped as specified below:

• E  This option corresponds to SQL:1992/Entry.

• I  This option corresponds to SQL:1992/Intermediate.

• F  This option corresponds to SQL:1992/Full.

• W  This option corresponds with Off.

• sa_ansi_standard_packages system procedure
• SQLFLAGGER function [Miscellaneous]
• sql_flagger_warning_level option [compatibility]
• SQL preprocessor