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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.