Example: HELP PROCEDURE Attributes Report - Teradata Vantage - Analytics Database

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;

Result:

     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;

Result:

      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