SQL Reference

SET CURRENT DEFAULT TRANSFORM GROUP

The SET CURRENT DEFAULT TRANSFORM GROUP statement changes the value of the CURRENT DEFAULT TRANSFORM GROUP special register. This statement is not under transaction control.

Invocation

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.

Authorization

No authorization is required to execute this statement.

Syntax

        .-CURRENT-.
>>-SET--+---------+--DEFAULT TRANSFORM GROUP-------------------->
 
     .- = --.
>----+------+---group-name-------------------------------------><
 

Description

group-name

Specifies a one-part name that identifies a transform group defined for all structured types. This name can be referenced in subsequent statements (or until the special register value is changed again using another SET CURRENT DEFAULT TRANSFORM GROUP statement).

The name must be an SQL identifier, up to 18 characters in length (SQLSTATE 42815). No validation that the group-name is defined for any structured type is made when the special register is set. Only when a structured type is specifically referenced is the definition of the named transform group checked for validity.

Rules

• If the value specified does not conform to the rules for a group-name, an error is raised (SQLSTATE 42815)
• The TO SQL and FROM SQL functions defined in the group-name transform group are used for exchanging user-defined structured type data with a host program.

Notes

• The initial value of the CURRENT DEFAULT TRANSFORM GROUP special register is the empty string.
• See CURRENT DEFAULT TRANSFORM GROUP for additional rules regarding the use of the special register.

Examples

Example 1:  Set the default transform group to MYSTRUCT1. The TO SQL and FROM SQL functions defined in the MYSTRUCT1 transform group will be used for exchanging user-defined structured type variables with the current host program.

   SET CURRENT DEFAULT TRANSFORM GROUP = MYSTRUCT1