Contents Index NEAREST_CENTURY option [compatibility] NULLS option [ISQL]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

NON_KEYWORDS option [compatibility]


Function 

Turns off individual keywords, allowing their use as identifiers.

Allowed values 

String

Default 

The empty string

See also 

Keywords

Description 

This option turns off individual keywords or all keywords introduced since a specific release of the product. 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.

In addition to specifying individual keywords, you can turn off all keywords since a specified release, using one of the following special values in the list of keywords:

keywords_4_0_d, keywords_4_0_c, keywords_4_0_b, keywords_4_0_a, keywords_4_0, keywords_5_0_01, keywords_5_0

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

SET OPTION NON_KEYWORDS = 'TRUNCATE, SYNCHRONIZE'

The following statement prevents all keywords introduced since release 4.0d from being recognized as keywords:

SET OPTION NON_KEYWORDS = 'keywords_4_0_d'

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 options is that SQL statements that use a turned off keyword cannot be used: they produce a syntax error.


Contents Index NEAREST_CENTURY option [compatibility] NULLS option [ISQL]