Procedure Attributes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
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.
  • UTF8 specifies the UTF8 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 International Character Set Support, B035-1125 for more information about the various collations supported by Vantage.
  • 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.
  • 13 specifies that the procedure was created in Teradata Database 16.0.
  • 14 specifies that the procedure was created in Teradata Database 17.0.
  • 15 specifies that the procedure was created in Teradata Database 17.20.
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.

Unicode Pass Through The session Unicode Pass Through attribute when the procedure was created or last altered.
  • 'S' is returned if Unicode Pass Through attribute was on.
  • 'F' is returned if Unicode Pass Through attribute was off.
Date Form The session date form setting when the procedure was created or last altered. For information about session date form settings, see Teradata Vantage™ - Database Utilities, B035-1102.