15.00 - Reserved Load Utility Reserved Query Bands - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Reserved Load Utility Reserved Query Bands

Note: As a general rule, customer‑written applications should not use these query band names. They are reserved for use by Teradata‑written applications and applications written by third party Teradata partners.

These reserved query bands are used by various Teradata load utilities. Do not use these query band names for your applications. They are only listed to make you aware that you should not use them in your own code.

  • UtilityName
  • Provides the name of the calling load utility. It represents the mechanism by which data is loaded, extracted, archived, or restored, either by a standalone utility such as FastLoad or by an embedded utility such as JDBC FastLoad.

    Customer‑written applications should not use this query band name to prevent conflicts. Applications using embedded utilities can rely on those utilities to set the query band name appropriately.

  • UtilityDataSize
  • Provides an estimate for the size of the data to be loaded, unloaded, backed up, or restored by a utility component. The following values are valid.

  • SMALL
  • MEDIUM
  • LARGE
  • Customer‑written applications should not use this query band name to prevent conflicts. Applications using embedded utilities can rely on those utilities to set the query band name appropriately.

    The following query band utility name values only work with load utilities and APIs that support the UtilityName and UtilityDataSize query band names. Do not use these reserved utility name values in your applications.

     

     UtilityName Value

                                                     Utility or API Supported

    ARC

    Archive

    Restore

    See Teradata Archive/Recovery Utility Reference for information about the Archive and Restore applications of the Archive/Recovery utility.

    CSPLOAD

    DUL csp command

    See “Dump Unload/Load” in Utilities: Volume 1 (A-K) and pdehelp for information about the csp command.

    FASTEXP

    FastExport

    See Teradata FastExport Reference for information about the CLIv2 version of the FastExport utility.

    FASTLOAD

    FastLoad

    See Teradata FastLoad Reference for information about the CLIv2 version of the FastLoad utility.

    JDBCE

    JDBC FastExport

    See ODBC Driver for Teradata User Guide for information about using the embedded JDBC version of the FastExport utility.

    JDBCL

    JDBC FastLoad

    See ODBC Driver for Teradata User Guide for information about using the embedded JDBC version of the FastLoad utility.

    MULTLOAD

    MultiLoad

    See Teradata MultiLoad Reference for information about using the CLIv2 version of the MultiLoad utility.

    TPTEXP

    Teradata Parallel Transporter EXPORT operator (FastExport emulation)

    See Teradata Parallel Transporter Reference and Teradata Parallel Transporter User Guide for information about the Teradata Parallel Transporter Export operator.

    TPTLOAD

    Teradata Parallel Transporter LOAD operator (FastLoad emulation)

    See Teradata Parallel Transporter Reference and Teradata Parallel Transporter User Guide for information about the Teradata Parallel Transporter Load operator.

    TPTUPD

    Teradata Parallel Transporter UPDATE operator (MultiLoad emulation)

    See Teradata Parallel Transporter Reference and Teradata Parallel Transporter User Guide for information about the Teradata Parallel Transporter Update operator.

    The following example is valid, but you should not use it. Its intent is only to demonstrate how reserved query band names and values are specified.

    This example creates a session query band using the reserved query band name UtilityName and the reserved query band value MULTLOAD, which is specific to the data handling processes of the MultiLoad data loading application. The query band is set for SESSION to enable continued operation across a restart.

         SET QUERY_BAND=‘UtilityName=MULTLOAD;’ FOR SESSION;

    See “Query Bands and Load Utilities” on page 865 for more information about query bands and load utilities.