The XML type in Field, Record, and Indicator modes uses transforms. The XML type has the following predefined transform groups to convert objects to CLOB, BLOB, VARCHAR, and VARBYTE.
| Transform Group | Complex Data Type | Primary Type | Default | Format |
|---|---|---|---|---|
| TD_XML_CLOB | XML | CLOB | Yes | Text format in CHARACTER SET UNICODE |
| TD_XML_BLOB | XML | BLOB | No | Text format in UTF-8 |
| TD_XML_VARCHAR | XML | VARCHAR(32000) | No | Text format in CHARACTER SET UNICODE |
| TD_XML_VARBYTE | XML | VARBYTE(64000) | No | Text format in UTF-8 |
You can use the TRANSFORM option in the CREATE PROFILE/MODIFY PROFILE or CREATE USER/MODIFY USER statements to specify for a user the transform group to use for a given data type.
Use the SET TRANSFORM GROUP FOR TYPE statement to change the active transform group in the current session. You can use this statement multiple times for a data type to switch from one transform group to another within the session. If the logon user already has transform settings, the statement modifies the transform settings for the current session.
Transform Group Macros
You can use the following macros to find the transform group for a CDT, or the transform group settings for a user, profile, or current session.
| Macro | Description |
|---|---|
| SYSUDTLIB.HelpCurrentUserTransforms | Lists the transform group settings of the current logon user. |
| SYSUDTLIB.HelpCurrentSessionTransforms | Lists the transform group settings of the current session. |
| SYSUDTLIB.HelpUserTransforms(User) | Lists the transform group settings for a specific user. |
| SYSUDTLIB.HelpCurrentUDTTransform(UDT) | Lists the transform group settings of the current session for the specified UDT. |
| SYSUDTLIB.HelpProfileTransforms(Profile) | Lists the transform group settings for a specific profile. |