String

Empty string

This option turns off individual keywords. This provides a way of ensuring that applications created with older versions of the product are not broken by new keywords. If you have an identifier in your database that is now a keyword, you can either add double quotes around the identifier in all applications or scripts, or turn off the keyword using the non_keywords option.

You cannot turn off the keywords set, option, and options. Whether a word is identified as a keyword is determined by the following (in order of precedence):

• It appears in the SQL Anywhere list of reserved words.
• It has been turned on with the reserved_keywords option.
• It has been turned off using the non_keywords option.

The following statement prevents TRUNCATE and SYNCHRONIZE from being recognized as keywords:

SET OPTION non_keywords = 'TRUNCATE, SYNCHRONIZE';

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

SET OPTION non_keywords =;

A side-effect of this option is that SQL statements that use a turned off keyword cannot be used: they produce a syntax error.

You can turn on individual keywords using the reserved_keywords option. See reserved_keywords option.

• Keywords
• Compatibility options
• non_keywords connection property
• reserved_keywords option