Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 22:00:59 GMT

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

<-- Anonymously Posted: Friday, July 08, 2005 17:55 -->

I'm wondering if it is possible to execute a macro with multiple criteria for a variable.

Example:

     replace macro my_macro( variable integer) as(
     sel * from table1 where field in :variable;
     );

     execute my_macro( (1,2,3) );

I'm trying to execute with multiple variables similar to above; however, I'm getting a syntax error. Is this possible??

Thanks,

Anomy Anom

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