QUERY_BAND= Data Set Option

Specifies whether to set a query band for the current transaction.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	none
Data source:	Teradata
See:	BULKLOAD= LIBNAME option, BULKLOAD= data set option, FASTEXPORT= LIBNAME option, Maximizing Teradata Load Performance, MULTILOAD= data set option, QUERY_BAND= LIBNAME option

Syntax

Details

Syntax

QUERY_BAND="pair-name=pair_value" FOR TRANSACTION;

Syntax Description

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

Details

Use this option to set unique identifiers on Teradata transactions and to add them to the current transaction. The Teradata engine uses this syntax to pass the name-value pair to Teradata.

SET QUERY_BAND="org=Marketing;report=Mkt4Q08;" FOR TRANSACTION;

For more information about this option and query-band limitations, see Teradata SQL Reference: Data Definition Statements.