pair_name - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-22
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Name component of a query band specification.

The maximum size for each pair_name is 128 UNICODE characters. For more information about database object names, see Teradata Vantage™ - SQL Fundamentals, B035-1141.

The number of pair_name=pair_value pairs is limited to the maximum length of the string, which is 4,096 UNICODE characters, including pad characters.

You must enclose the set of name=value pairs for the query band with APOSTROPHE characters. If an APOSTROPHE character is embedded within a pair name, you must type it twice, to escape it. Otherwise, the system interprets it as a pair_name=pair_value string terminator.

pair_name cannot contain any of the following characters:

  • EQUALS SIGN (=)
  • SEMICOLON (;)
  • a null
Do not specify any reserved pair name except BINPACKALGO4PARQUET, which sets the binpacking algorithm to use when reading Parquet files. The binpacking algorithm determines how the files are distributed on the AMPs.

For a list of reserved query band names, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.