Purpose
Invokes a method associated with a UDT.
Syntax
- database_name
- A qualifier for the column_name.
- table_name
- A qualifier for the column_name.
- column_name
-
The name of a distinct or structured UDT column.
Constructor methods have the same name as the UDT with which they are associated.
- udf_name
-
The name of a distinct or structured UDT data type.
Constructor methods have the same name as the UDT with which they are associated.
- argument
-
An argument to the UDF.
An argument to pass to the constructor.
An argument to pass to the method.
Parentheses must appear even though the argument list may be empty.
- CAST
-
A CAST expression that converts a source data type to a distinct or structured UDT.
Data type conversions involving UDTs require appropriate cast definitions for the UDTs. To define a cast for a UDT, use the CREATE CAST statement. For more information on CREATE CAST, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- expression
- An expression that results in a data type that is compatible as the source type of a cast definition for the target UDT.
- NEW
- An expression that constructs a new instance of a structured type and initializes it using the specified constructor method.
- SYSUDTLIB.
-
The database in which the constructor exists.
Teradata Database only searches the SYSUDTLIB database for UDT constructors, regardless of whether the database name appears in the expression.
- constructor_name
-
The name of a constructor method associated with a UDT.
Constructor methods have the same name as the UDT with which they are associated.
- method_name
-
The name of an observer, mutator, or user-defined method (UDM).
You must precede each method name with a period.