15.00 - 6904 The target data type of the User-defined Transform should be a %VSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

6904 The target data type of the User-defined Transform should be a %VSTR.

Explanation:

The target data type of a FromSQL transform should be a Pre-defined Base Type whereas a ToSQL transform should be a UDT.

Generated By:

Syntaxer/Resolver and Optimizer Modules

For Whom:

Internal

Remedy:

Use the auto-generated implicitly assignable user-defined CAST.