15.00 - 6867 The %VSTR routine has invalid number of parameters - 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)

6867 The %VSTR routine has invalid number of parameters

Explanation:

A routine has invalid number of parameters: --The TO SQL UDF of a UDT Transform Group must have only one declared parameter. --The FROM SQL routine of a UDT Transform Group must have only one declared parameter, if the routine is a UDF. --The FROM SQL routine of a UDT Transform Group must not have any declared parameter, if the routine is a UDM. --The Cast routine specified in a CREATE/REPLACE CAST statement must declare only one parameter if the Cast routine is a UDF. The Cast routine must not declare any parameter if the Cast routine is a UDM (the system will automatically generate the SELF parameter for the UDM).

Generated By:

RES modules.

For Whom:

End User.

Remedy:

Specify a routine with the correct number of parameter(s) and re-submit the query.