SET CURRENT RULES

The SET CURRENT RULES statement assigns a value to the CURRENT RULES special register.

Invocation

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.

Authorization

None required.

Syntax

Read syntax diagram
>>-SET CURRENT RULES--=--+-string-constant-+-------------------><
                         '-host-variable---'   

Description

This statement replaces the value of the CURRENT RULES special register with the value of the string constant or host variable. The value must be a character string that is 3 bytes in length, and the value must be 'DB2®' or 'STD'.

Notes

For the effect of the values 'DB2' and 'STD' on the execution of certain SQL statements, see CURRENT RULES.

Example

Set the SQL rules to be followed to DB2. 
  EXEC SQL SET CURRENT RULES = 'DB2';