1  SET_KEYWORD_RULES
   Specifies whether or not you can use identifiers as keywords in
   the current attach.
 

2  Environment
   You can use the SET KEYWORD RULES statement:

   o  In interactive SQL

   o  Embedded in host language programs to be precompiled

   o  As part of a procedure in an SQL module

   o  In dynamic SQL as a statement to be dynamically executed
 

2  Format

 SET KEYWORD RULES -----> runtime-options ------>
 



 runtime-options
 
 --+---> 'string-literal' ------+----->
   +---> parameter -------------+
   +---> parameter-marker ------+

 

2  Arguments
 

3  parameter

   Specifies the value of runtime-options, which must be one of the
   following:

   o  SQL99

   o  SQL92

   o  SQL89

   o  MIA

   o  SQLV40
 

3  parameter-marker

   Specifies the value of runtime-options, which must be one of the
   following:

   o  SQL99

   o  SQL92

   o  SQL89

   o  MIA

   o  SQLV40
 

3  MIA

   Specifies that SQL returns an error if statements use keywords
   (reserved words) as identifiers, unless the keywords are enclosed
   in double quotation marks.
 

3  'string-literal'

   Specifies the value of runtime-options, which must be one of the
   following:

   o  SQL99

   o  SQL92

   o  SQL89

   o  MIA

   o  SQLV40
 

3  SQL89

   Specifies that SQL returns an error if statements use keywords
   (reserved words) as identifiers, unless the keywords are enclosed
   in double quotation marks.
 

3  SQL92

   Specifies that SQL returns an error if statements use keywords
   (reserved words) as identifiers, unless the keywords are enclosed
   within double quotation marks.
 

3  SQL99

   Specifies that SQL returns an error if statements use keywords
   (reserved words) as identifiers, unless the keywords are enclosed
   within double quotation marks.
 

3  SQLV40

   Specifies that SQL returns an error if statements use keywords
   (reserved words) as identifiers, unless the keywords are enclosed
   within double quotation marks.
 

2  Examples
   Example 1: Setting the keyword rule characteristics to SQL99

   SQL> SET KEYWORD RULES 'SQL99';
   SQL> --
   SQL> -- Because NATIONAL is a keyword, SQL returns an error message.
   SQL> --
   SQL> CREATE DOMAIN NATIONAL CHAR (2);
   %SQL-F-RES_WORD_AS_IDE, Keyword NATIONAL used as an identifier
   SQL> --
   SQL> -- Enclose NATIONAL in double quotation marks.
   SQL> --
   SQL> CREATE DOMAIN "NATIONAL" CHAR (2);
   SQL> --

   Example 2: Setting the keyword rule characteristics to SQLV40

   SQL> SET KEYWORD RULES 'SQLV40';
   SQL> --
   SQL> -- You can use a keyword as an identifier.
   SQL> --
   SQL> CREATE DOMAIN NATIONAL CHAR (2);
   %SQL-I-DEPR_FEATURE, Deprecated Feature: Keyword national used as an identifier
   SQL> --