Constructs a new instance of a structured type and initializes it using the specified constructor method or function.
ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.
The requirement that parentheses appear when the argument list is empty is a Teradata extension to preserve compatibility with existing applications.
Syntax
[ NEW [SYSUDTLIB.] ] constructor_name ( [ argument [,...]] )
Syntax Elements
- SYSUDTLIB.
- Name of the database where the function is located.
- constructor_name
- The name of a distinct or structured UDT column.
- argument
An argument to pass to the constructor.
Parentheses must appear even though the argument list may be empty.