16.20 - CREATE TRANSFORM and REPLACE TRANSFORM - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

Creates or replaces transform groups for importing UDT data from a client system to a Teradata Database and exporting UDT data from a Teradata Database to a client system. You can use CREATE TRANSFORM to add transform groups in addition to the existing transform groups. REPLACE TRANSFORM drops all of the existing transform groups and adds the transform groups you specify.

Required Privileges

You must have at least one of the following privileges on the SYSUDTLIB database to perform CREATE TRANSFORM or REPLACE TRANSFORM:
  • UDTMETHOD
  • UDTTYPE

If any of the external routines you specify is a UDF, then you must also have the EXECUTE FUNCTION privilege on the UDF, and the UDF must be contained within the SYSUDTLIB database.

Syntax