17.00 - Example: Adding Multiple Instance Methods to a Structured UDT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

The following example adds two instance methods named toYen() and toPeso() to the structured UDT named euro:

    ALTER TYPE euro         /* Add 2 original methods */
     ADD INSTANCE METHOD 
      toYen() 
        RETURNS yen
        LANGUAGE C
        PARAMETER STYLE SQL
        DETERMINISTIC
        NO SQL,
      toPeso() 
        RETURNS peso
        LANGUAGE C
        PARAMETER STYLE SQL
        DETERMINISTIC
        NO SQL;