Teradata Database Message 6864 - 6864 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
The %VSTR routine must be UDF.
Explanation
A routine is expected to be User Defined Function. -- The TO SQL routine specified in a CREATE TRANSFORM statement must be a UDF. -- The CAST routine specified in a CREATE/REPLACE CAST statement must be a UDF if the Source data type for the CAST is pre-defined type and the Target data type is Distinct or Structured UDT type.
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
Correct and re-submit the query.