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) |
|---|---|
| Category: | Data Set Control |
| 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 |
Table of Contents
specifies a name and value pair of a query band for the current transaction.
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:
data db.new_table (QUERY_BAND="org=Sales; process=Build_Initial;");
set work.sasdata1;
run;For more information about this option and query-band limitations, see Teradata SQL Reference: Data Definition Statements.