Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > SET CURRENT DEGREE

SET CURRENT DEGREE

This command is supported only syntactically by the XDB Server.

Invocation

SET CURRENT DEGREE is an executable statement that can be embedded in an application program, issued interactively, or dynamically prepared.

Authorization

No special authorization is required.

Syntax

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 }

Parameters:

`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).

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.

Example:

The following example sets the CURRENT DEGREE special register to the string "ANY".

SET CURRENT DEGREE = 'ANY'