Example: HELP TYPE with METHOD Option - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

The following example shows the report produced by submitting HELP TYPE with the METHOD option.

Suppose you have the following type definition.

    CREATE TYPE my_structured_type AS (
      attribute_1 DECIMAL(8,2), 
      attribute_2 REAL,
      attribute_3 VARCHAR(20) ) 
    NOT FINAL
    /* Signature of constructor method my_structured_type */
    CONSTRUCTOR METHOD my_structured_type( P1 INTEGER ) 
    RETURNS my_structured_type
    SPECIFIC my_structured_type_c1 
    SELF AS RESULT 
    LANGUAGE C 
    PARAMETER STYLE SQL
    DETERMINISTIC 
    NO SQL,
    /* Signature of instance method Method1 */
    METHOD method_1(VARCHAR(20)) 
    RETURNS INTEGER 
    LANGUAGE C 
    NO SQL 
    PARAMETER STYLE SQL;

Now you submit the following HELP TYPE request for my_structured_type with the METHOD option.

     HELP TYPE my_structured_type METHOD; 
      *** Help information returned. 8 rows.
      *** Total elapsed time was 1 second.
        Method Name   ATTRIBUTE3
      Specific Name   MYSTRUCTUR_ATTRIBUTE3_04E1_M
        Method Type   M
          Null Call   Y
          Exec Mode   NP
     Deterministic   Y
        Method Name   ATTRIBUTE3
      Specific Name   MYSTRUCTUR_ATTRIBUTE3_04E0_O
        Method Type   O
          Null Call   N
          Exec Mode   NP
     Deterministic   Y
        Method Name   ATTRIBUTE2
      Specific Name   MYSTRUCTUR_ATTRIBUTE2_04DF_M
        Method Type   M
          Null Call   Y
          Exec Mode   NP
     Deterministic   Y
        Method Name   ATTRIBUTE2
      Specific Name   MYSTRUCTUR_ATTRIBUTE2_04DE_O
        Method Type   O
          Null Call   N
          Exec Mode   NP
     Deterministic   Y
        Method Name   ATTRIBUTE1
      Specific Name   MYSTRUCTUR_ATTRIBUTE1_04DD_M
        Method Type   M
          Null Call   Y
          Exec Mode   NP
     Deterministic   Y
        Method Name   ATTRIBUTE1
      Specific Name   MYSTRUCTUR_ATTRIBUTE1_04DC_O
        Method Type   O
          Null Call   N
          Exec Mode   NP
     Deterministic   Y
        Method Name   MYSTRUCTUREDTYPE
      Specific Name   MYSTRUCTUREDTYPE_C1
        Method Type   C
          Null Call   Y
          Exec Mode   P
     Deterministic   Y
        Method Name   METHOD1
      Specific Name   MYSTRUCTUR_METHOD1_04DB_R
        Method Type   I
          Null Call   Y
          Exec Mode   P
     Deterministic   N