15.00 - Procedure Attributes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Procedure Attributes

 

Attribute

Description

Transaction Semantics

  • ANSI specifies ANSI transaction semantics.
  • TERADATA specifies Teradata transaction semantics.
  • Platform

    LINUX specifies the Linux operating system

    Character Set

  • ASCII specifies the ASCII character set.
  • EBCDIC specifies the EBCDIC character set.
  • KANJISJIS specifies the Kanji Shift Japanese Industrial Standard Code (DOS Kanji) character set.
  • KANJIEBCDIC specifies the Kanji EBCDIC character set.
  • Default Character Data Type

  • GRAPHIC specifies the IBM DB2 Graphic server character data type.
  • KANJI1 specifies the non‑canonical Kanji server character data type.
  • KANJISJIS specifies the canonical Kanji: Shift Japanese Industrial Standard server character data type.
  • LATIN specifies the Teradata Latin server character data type.
  • UNICODE specifies the Unicode server character data type.
  • Collation

    The following collations are supported. See “CREATE USER” on page 769 or International Character Set Support for more information about the various collations supported by Teradata Database.

  • ASCII
  • CHARSET_COLL
  • EBCDIC
  • JIS_COLL
  • MULTINATIONAL
  • Stored Procedure Text

  • N specifies that statements defining the procedure are not stored.
  • Y specifies that statements defining the procedure are stored in the procedure object.
  • Version Number

  • 00 specifies that the procedure was created in V2R4.0.
  • 01 specifies that the procedure was created in V2R4.1.
  • 02 specifies that the procedure was created in V2R4.2.
  • 03 specifies that the procedure was created in V2R5.0.
  • 04 specifies that the procedure was created in V2R5.1.
  • 05 specifies that the procedure was created in V2R6.0.
  • 06 specifies that the procedure was created in V2R6.1.
  • 07 specifies that the procedure was created in V2R6.2.
  • 08 specifies that the procedure was created in Teradata Database 12.0.
  • 09 specifies that the procedure was created in Teradata Database 13.0.
  • 10 specifies that the procedure was created in Teradata Database 13.10.
  • 11 specifies that the procedure was created in Teradata Database 14.0.
  • 12 specifies that the procedure was created in Teradata Database 14.10.
  • Default Database

    The default database name for procedures created in Teradata Database V2R4.0 and up is NULL.

    Warning Option

  • N specifies that all compilation warnings are suppressed.
  • Y is the default.
  • It specifies that all compilation warnings generated during procedure compilation or recompilation are returned to the user.

    Creation Timezone

    The time zone offset when the procedure was created or last altered.

    Creation Timezone String

    The time zone string used to set the time zone offset for the procedure when it was created or last altered.

    If the procedure was created or altered using a GMT time zone specification, nothing is returned.