16.20 - Procedure Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
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 or Teradata Vantage™ NewSQL Engine International Character Set Support, B035-1125 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 V2R6.0.
  • 05 specifies that the procedure was created in V2R6.2.
  • 06 specifies that the procedure was created in V2R7.0.
  • 07 specifies that the procedure was created in Teradata Database 13.0.
  • 08 specifies that the procedure was created in Teradata Database 13.10.
  • 09 specifies that the procedure was created in Teradata Database 14.0.
  • 10 specifies that the procedure was created in Teradata Database 14.10.
  • 11 specifies that the procedure was created in Teradata Database 15.0.
  • 12 specifies that the procedure was created in Teradata Database 15.10.
Default Database The default database name for the procedure is the creator’s default database.
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.