Teradata Database Message 6904 - 17.10 - 6904 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
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
Notes
None
Remedy
Use the auto-generated implicitly assignable user-defined CAST.