Controls the response to any SQL that is not part of the specified standard.
W
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 |
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 warning flagging off.
For compatibility with previous versions, the following values are also accepted:
This option corresponds to SQL:1992/Entry.
This option corresponds to SQL:1992/Intermediate.
This option corresponds to SQL:1992/Full.
This option corresponds to Off.