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

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;