QUERY_BAND= LIBNAME Option

Specifies whether to set a query band for the current session.
Valid in: SAS/ACCESS LIBNAME statement
Default: none
Data source: Teradata
See: QUERY_BAND= data set option, BULKLOAD= LIBNAME option, BULKLOAD= data set option, FASTEXPORT= LIBNAME option, Maximizing Teradata Load Performance , MULTILOAD= data set option

Syntax

QUERY_BAND=pair-name=pair_value” FOR SESSION;

Syntax Description

pair-name=pair_value
specifies a name and value pair of a query band for the current session.

Details

Use this option to set unique identifiers on Teradata sessions and to add them to the current session. The Teradata engine uses this syntax to pass the name-value pair to Teradata.
SET QUERY_BAND="org=Marketing;report=Mkt4Q08;" FOR SESSION;
For more information about this option and query-band limitations, see Teradata SQL Reference: Data Definition Statements.