17.00 - Example: HELP PROCEDURE Attributes Report - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

You have created the procedure named sp1new using the time zone string AMERICA PACIFIC. The HELP PROCEDURE output for sp1new looks like this.

     HELP PROCEDURE pa.sp1new ATTRIBUTES;
     Transaction Semantics TERADATA
                 Print Mode N
                   Platform LINUX
              Character Set ASCII
Default Character Data Type LATIN
                  Collation ASCII
                   SPL Text Y
             Version Number 09
           Default Database PA
             Warning Option Y
          Creation Timezone -07:00
   Creation Timezone String AMERICA PACIFIC
      Unicode Pass Through  S

Suppose you then alter procedure sp1new, recompiling it at time zone GMT ‘01:00’.

     ALTER PROCEDURE pa.sp1new COMPILE AT TIME ZONE ‘01:00’;

The HELP PROCEDURE output for sp1new now looks like this. Because you specified the time zone using GMT terminology rather than a time zone string, Vantage does not report a time zone string.

     HELP PROCEDURE pa.sp1new ATTRIBUTES;
      Transaction Semantics TERADATA
                 Print Mode N
                   Platform LINUX
              Character Set ASCII
Default Character Data Type LATIN
                  Collation ASCII
                        SPL Y
             Version Number 09
           Default Database PA
             Warning Option Y
          Creation Timezone 01:00
   Creation Timezone String 
      Unicode Pass Through  S