 |
|
| Data Set Options for Relational Databases |
QUERY_BAND= Data Set Option
Specifies whether to set a query band for the current transaction.
| Default value: | none |
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
| DBMS support: | Teradata |
| Syntax | |
| Syntax Description | |
| Details | |
| See Also |
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.
| See Also |
To assign this option to a group of relational DBMS tables or views, see the QUERY_BAND= LIBNAME Option.
Maximizing Teradata Load Performance
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.