Example: Adding an Instance Method to a Structured UDT - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following example adds a new instance method named toYen() to the structured UDT named euro:

ALTER TYPE euro   /* Add original method */
 ADD INSTANCE METHOD toYen() 
 RETURNS yen
 LANGUAGE C
 PARAMETER STYLE SQL
 DETERMINISTIC
 NO SQL;