Usage Notes - 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™

QueryBand Field Length

The HELP SESSION output includes these query band fields:
  • QueryBand
  • Session QueryBand
  • Transaction QueryBand
  • Profile QueryBand
The QueryBand field is a concatenation of the session and transaction query bands. When the DBSControl field MaxSetQueryBandSize is greater than 2K and the host character set export width is greater than one, the HELP SESSION QueryBand field may be truncated to prevent the HELP SESSION output from exceeding the 64KB row size limit. The Session QueryBand, Transaction QueryBand, and Profile QueryBand fields are not truncated. For more information on export width specifications, see Valid Export Width Specifications. For more information on the DBSControl field MaxSetQueryBandSize, see Teradata Vantage™ - Database Utilities, B035-1102. To find the full concatenated query band string for the current transaction, session, and profile, use the GetQueryBand function. For more information about the GetQueryBand function, see Teradata Vantage™ - Application Programming Reference, B035-1090.