UDTのSQL定義 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL外部ルーチン プログラミング

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/qwr1571437338192.ditamap
dita:ditavalPath
ja-JP/qwr1571437338192.ditaval
dita:id
B035-1147
Product Category
Software
Teradata Vantage

color_t DISTINCT型UDTと、circle_t STRUCTURED型UDTのSQL定義を以下に示します。DISTINCT型UDTであるcolor_tの変換、キャスト、および整列の機能は、Teradata Databaseによって自動生成されます。

CREATE TYPE color_t
   AS VARCHAR(30)
   FINAL;

CREATE TYPE circle_t
   AS (x INTEGER, y INTEGER, radius INTEGER, color color_t)
   NOT FINAL
   CONSTRUCTOR METHOD circle_t( x INTEGER,
                                y INTEGER,
                                radius INTEGER,
                                color color_t )
      RETURNS circle_t
      SPECIFIC circle_t_constructor
      SELF AS RESULT
      NO SQL
      PARAMETER STYLE TD_GENERAL
      DETERMINISTIC
      LANGUAGE C,
   INSTANCE METHOD circle_t_FromSql()
      RETURNS VARCHAR(80)
      SPECIFIC circle_t_FromSql
      NO SQL
      PARAMETER STYLE TD_GENERAL
      DETERMINISTIC
      LANGUAGE C,
   INSTANCE METHOD circle_t_Ordering()
      RETURNS FLOAT
      SPECIFIC circle_t_Ordering
      NO SQL
      PARAMETER STYLE SQL
      DETERMINISTIC
      LANGUAGE C,
   INSTANCE METHOD VarcharCast()
      RETURNS VARCHAR(80)
      SPECIFIC circle_t_Cast
      NO SQL
      PARAMETER STYLE TD_GENERAL
      DETERMINISTIC
      LANGUAGE C;