Probelm with Query Band

Database
Enthusiast

Probelm with Query Band

Hello,

I am facing some problems with Query Banding. Whenever I am trying the following I am getting an error
SET QUERY_BAND = 'Group=Finance;JobID=Fin123;' FOR SESSION;

Error Message - Invalid SET statement in the triggered action.

When I checked the manual, it says that SET statement can be used only form Triggers & I was trying it from BTEQ.

Is there any way to invoke Query Banding from BTEQ? I am using V2R6.

Thanks in Advance.

Regards,
Somnath Roy
2 REPLIES
Senior Apprentice

Re: Probelm with Query Band

Hi Somnath,
this is a strange error message.

Query band is available since TD12, are you running on a lower version?

Dieter
Enthusiast

Re: Probelm with Query Band

Yes.. I am running on TD6. But when I noticed the DBQL table, it has got the QueryBand column in it. So I thought it is available in TD6 itself.

Please help me to understand