Load Utility Reserved Query Bands - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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. For more information about query bands and load utilities, see Query Bands and Load Utilities.

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.

Following are the load utility reserved query bands:

Query Band Description
DSAJobType Specifies either backup or restore. Applicable to the session query band only.
UtilityAWT Specifies the number of AWTs required for the current job. Applicable to the session query band only.
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.

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.

Reserved Query Band Load Utility Names

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

UtilityName Value Utility or API Supported
CSPLOAD DUL csp command

For information about the csp command, see “Dump Unload/Load” in Teradata Vantage™ - Database Utilities , B035-1102 and pdehelp.

FASTEXP FastExport

For information about the CLIv2 version of the FastExport utility, see Teradata® FastExport Reference, B035-2410.

FASTLOAD FastLoad

For information about the CLIv2 version of the FastLoad utility, see Teradata® FastLoad Reference, B035-2411.

JDBCE JDBC FastExport

For information about using the embedded JDBC version of the FastExport utility, see ODBC Driver for Teradata® User Guide.

JDBCL JDBC FastLoad

For information about using the embedded JDBC version of the FastLoad utility, see ODBC Driver for Teradata® User Guide.

MULTLOAD MultiLoad

For information about using the CLIv2 version of the MultiLoad utility, see Teradata® MultiLoad Reference, B035-2409.

TPTEXP Teradata Parallel Transporter EXPORT operator (FastExport emulation)

For information about the Teradata Parallel Transporter Export operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.

TPTLOAD Teradata Parallel Transporter LOAD operator (FastLoad emulation)

For information about the Teradata Parallel Transporter Load operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.

TPTUPD Teradata Parallel Transporter UPDATE operator (MultiLoad emulation)

For information about the Teradata Parallel Transporter Update operator, see Teradata® Parallel Transporter Reference, B035-2436 and Teradata® Parallel Transporter User Guide, B035-2445.