Teradata Database Message 6806 - 6806 - Analytics Database - Teradata Vantage

Message

Constructor Functions Are Functional Representation of Constants and As Such They Must Not Contain Any Table References.

Explanation

This error occurs when a Constructor Function contains a Table Reference in its parameter list. A constructor function is a declaration of a UDT constant. Parameters are used to initialize the constant to some state. All Parameters to a Constructor Function must themselves be constants. Thus the parameters for a constructor function cannot contain any table references in its parameter list.

Generated By

OPT module.

For Whom

End User.

Notes

User SQL statement construction error.

Remedy

Type in Constructor Function Using only constants as parameters