Archives of the TeradataForum

Message Posted: Thu, 08 Jul 2010 @ 17:54:45 GMT

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

Remember, the query band expression must be a string, hence a value enclosed by single quotes.

Try:

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

Dave

David W. Roth
Teradata Certified Master
TERADATA

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