15.10 - QueryBandReservedNames_TBF - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Returns all the query band names and descriptions, including those dropped from a release.

REPLACE FUNCTION SYSLIB.QueryBandReservedNames_TBF ()
  RETURNS TABLE 
   (queryband_name     VARCHAR(128) CHARACTER SET UNICODE, 
    release_introduced CHAR(5) CHARACTER SET LATIN,
    release_dropped    CHAR(5) CHARACTER SET LATIN,
    category           CHAR(1) CHARACTER SET LATIN,
    max_len            INTEGER,
    default_value      VARCHAR(256) CHARACTER SET UNICODE,
    description        VARCHAR(512) CHARACTER SET UNICODE,
    queryband_type     CHAR(1) CHARACTER SET LATIN
   )
 								.
								.
								.
;
 
REPLACE VIEW SYSLIB.QueryBandReservedNames AS
        SELECT queryband_name, category, max_len, 
          default_value, description, queryband_type
        FROM TABLE (QueryBandReservedNames_TBF()) as t1
        WHERE release_dropped IS NULL
; 

The QueryBandReservedNames view returns the current query band names only.

The QueryBandReservedNames_TBF function and QueryBandReservedNames view are created in the SYSLIB database by the DEM DIP script. The privileges to use the QueryBandReservedNames_TBF function and QueryBandReservedNames view are granted to PUBLIC.

 

Column Name

Description

Queryband_Name

Name of the query band.

Release_Introduced

Version number of when the query band name was introduced.

The version number is at the granularity of a minor release in standard format (that is, two digits for a major release number followed by a period and two digits for a minor release number). For example, '15.0' and '15.10'.

Release_Dropped

Value is either NULL or the version number of when the query band name was dropped. The version number is at the granularity of a minor release in standard format (that is, two digits for a major release number followed by a period and two digits for a minor release number). For example, '15.0' and '15.10'.

Category

  • T = The Teradata restricted name. These query band names are directives to Teradata Database.
  • A = The Application query band name. These query band names are recommended names for use by Teradata, Customer, and Partner applications.
  • I = The Teradata internal name. These query band names are for internal Teradata use and should not be used by applications.
  • Max_Len

    Maximum length of the value for the property. The default is 256.

    Default_Value

    Default value of the property, which is NULL.

    Description

    Description of how the query band name is used and whether it is appropriate for a session or transaction query band, or both.

    Queryband_Type

  • S = The session query band.
  • T = The Transaction query band.
  • B = The session and transaction query band.
  • SELECT queryband_name(FORMAT 'X(30)'), release_introduced from table(queryband
    reservednames_tbf()) as t1 order by 1;
     
     *** Query completed. 28 rows found. 2 columns returned.
     *** Total elapsed time was 3 seconds.
     
    queryband_name                  release_introduced
    ------------------------------  ------------------
    ACTION                          12.00
    APPLICATIONNAME                 12.00
    BLOCKCOMPRESSION                14.10
    CLIENTUSER                      12.00
    DEADLINE                        12.00
    DESTINATION                     12.00
    GROUP                           12.00
    IMPORTANCE                      12.00
    JOBDEADLINE                     12.00
    JOBID                           12.00
    JOBLEN                          12.00
    JOBSEQ                          12.00
    MAXQUERYTIME                    12.00
    PROXYROLE                       13.00
    PROXYUSER                       13.00
    QUERYISSUETIME                  12.00
    REDRIVE                         14.10
    SOURCE                          12.00
    STARTIME                        12.00
    TVSMIGRATION                    13.10
    TVSTEMPERATURE                  13.10
    TVSTEMPERATURE_FALLBACK         14.10
    TVSTEMPERATURE_FALLBACKCLOBS    14.10
    TVSTEMPERATURE_PRIMARY          14.10
    TVSTEMPERATURE_PRIMARYCLOBS     14.10
    UTILITYDATASIZE                 13.10
    UTILITYNAME                     13.10
    VERSION                         12.00