Query Band Syntax

Database
NV
N/A

Query Band Syntax

Is it possible to write a Query Band statement without a ; in the clause?

Ex:

SET QUERY_BAND = 'A=B' For Session;
Tags (1)
4 REPLIES
Senior Apprentice

Re: Query Band Syntax

No, it's part of the syntax.

So why not just adding the semicolon?

Dieter

Enthusiast

Re: Query Band Syntax

Hello,

I'm new to query band.  Pl. explain what exactly it does.

Thanks in advance.

Teradata Employee

Re: Query Band Syntax

Querybanding provides a mechanism for enterprise applications to collaborate with the underlying Teradata Database in order to provide for better accounting, prioritization, and workload management.  Querybanding provides the capability to wrap metadata around a query (i.e. band the query with metadata). For instance, informing Teradata of the actual user submitting a query through a third party application allowing additional differentiation.

Enthusiast

Re: Query Band Syntax

Thanks for the great feedback guys in general and gryback in particular.

I'd like to use Query band with SAS queries and wondering how this can be used and the advantages through SAS. Any example would be a great help !

Thank you in advance !