SET CURRENT RULES statement

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

Invocation for SET CURRENT RULES

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

Authorization for SET CURRENT RULES

None required.

Syntax for SET CURRENT RULES

Read syntax diagramSkip visual syntax diagramSET CURRENT RULES= string-constanthost-variable

Description for SET CURRENT RULES

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 SET CURRENT RULES

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

Example for SET CURRENT RULES

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