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 SAP 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 = ;