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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

sql_flagger_error_level option

Controls the response to any SQL 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
  • SQL:2008/Core
  • SQL:2008/Package
  • UltraLite
Default

W

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

This option flags any SQL 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 error flagging off.

For compatibility with previous SQL Anywhere versions, the following values are also accepted:

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