SET CURRENT DEGREE is an executable statement that can be embedded in an application program, issued interactively, or dynamically prepared.
No special authorization is required.
This command is supported only syntactically.
SET CURRENT DEGREE = { string-constant | host-variable }
This command is supported only syntactically.
SET CURRENT DEGREE = { string-constant | host-variable }
string-constant | When used with DB2, this string constant value must be a character string not longer than three bytes, and enclosed in quotation marks (see DB2 documentation for allowed values). |
host-variable | When used with DB2, this host variable value must be a character string not longer than three bytes (see DB2 documentation for allowed values). |
The following example sets the CURRENT DEGREE special register to the string "ANY".
SET CURRENT DEGREE = 'ANY'
Description
On mainframe DB2 systems, this command assigns a value to the CURRENT DEGREE special register. On the XDB Server, this command also places a value in the CURRENT DEGREE special register, although the "degree of parallelism" is not affected. See your DB2 documentation for more information.