RESERVED_KEYWORDS Option

Turns on individual keywords that are disabled by default.

Allowed Values

String

Default

Empty string

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Remarks

This option turns on individual keywords that are disabled by default. Only the LIMIT keyword can be turned on.

Examples

The following statement allows the LIMIT keyword to be recognized as a keyword:

SET OPTION RESERVED_KEYWORDS = 'LIMIT';
You cannot turn on the keywords SET, OPTION, and OPTIONS. The following determine whether a word is identified as a keyword (in order of precedence):
  • It appears in the SQL Anywhere list of reserved words
  • It is turned on with the RESERVED_KEYWORDS option
  • It is turned off with the NON_KEYWORDS option

Each setting of this option replaces the previous setting. The following statement clears all previous settings:

SET OPTION RESERVED_KEYWORDS = ;