sql_flagger_error_level option

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

Off

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role.

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.

sql_flagger_error_level option

Allowed values

Default

Scope

Remarks

See also