16.20 - Example: Adding Multiple Instance Methods to a Structured UDT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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;