 |
|
| The LIBNAME Statement for Relational Databases |
QUERY_BAND= LIBNAME Option
Specifies whether to set a query band for the current session.
| Default value: | none |
| Valid in: | SAS/ACCESS LIBNAME statement |
| DBMS support: | Teradata |
| Syntax | |
| Syntax Description | |
| Details | |
| See Also |
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.
| See Also |
To apply this option to an individual data set, see the QUERY_BAND= Data Set Option.
Maximizing Teradata Load Performance
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.