15.10 - Example: Adding Multiple Instance Methods to a Structured UDT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
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;