15.00 - Default Transform Group For a Structured UDT - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Default Transform Group For a Structured UDT

Unlike the case for distinct UDTs, the system does not create a default transform group for a newly created structured UDT; however, you must create a transform group for a new structured type before you can use it as a column type for a table or use it in conjunction with operations involving the import or export of data defined with that structured type. If you attempt to use a new structured UDT without first defining a transform group for it, the request aborts and the system returns an error to the requestor.

To define a transform group for a new structured UDT, use the CREATE TRANSFORM statement (see “CREATE TRANSFORM/ REPLACE TRANSFORM” on page 694).

To determine if a structured UDT has a defined transform, use the HELP TYPE statement (see “HELP TYPE” on page 972).