Archives of the TeradataForum

Message Posted: Thu, 08 Jul 2010 @ 12:19:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Experts,

I am facing an issue with Query Band when I am using it in Macro.

     SET QUERY_BAND = 'AppId=' || :app_id || ';'  FOR TRANSACTION;

I am taking app_id from the input variable given.

It is throwing an error.

it is throwing a Invalid SET statement error at compile time

Version details of the database is

     LANGUAGE SUPPORT MODE    Standard
     RELEASE                  12.00.03.03
     VERSION                  12.00.03.01a

Please help me.

Thanks,

Prasad K K

	<Prev	Next>		<<First	<Prev	Next>	Last>>