Specifies whether to set a query band for the current session.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Requirement: | A semi-colon ( ; ) is required before the ending quotation mark in order for the database to process "pair-name=pair_value;" |
| Data source: | Teradata |
| See: | BULKLOAD= LIBNAME option, BULKLOAD= data set option, FASTEXPORT= LIBNAME option, Maximizing Teradata Load Performance, MULTILOAD= data set option, QUERY_BAND= data set option |
Table of Contents
specifies a name and value pair of a query band for the current session.
Use this option to set unique identifiers in Teradata sessions and to add them to the current session. The Teradata engine uses this syntax to pass the name-value pair to Teradata:
libname db teradata user=myusr1 password=mypwd1
QUERY_BAND="org=Marketing;report=Mkt4Q08;";For more information about this option and query-band limitations, see Teradata SQL Reference: Data Definition Statements.