Procedure Attributes - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™
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™ - Advanced SQL 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.