15.10 - About Query Banding and Middle Tier Applications - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

End users can connect to Teradata Database through middle-tier (non-Teradata) applications using pooled sessions. You can use the SET QUERY_BAND statement to attach metadata to end user SQL queries that cannot otherwise be associated with the session.

Application users with SQL privileges can submit SET QUERY_BAND statements. For users who cannot submit SQL, you can program the application to inject a SET QUERY_BAND statement containing the needed metadata.