15.10 - Example: HELP PROCEDURE Attributes Report - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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

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, Teradata Database 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