Archives of the TeradataForum

Message Posted: Wed, 18 Aug 2004 @ 08:06:37 GMT

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

Thanks Michael for the help.

But I also want to pass multiple values. I donot want to declare those many variables for each parameter.

I want one variable to take multiple entries just like IN..

For ex. when I write

     Macro name (x datatype)
     As
     (select ------------where fieldname in (:x)
     )

It gives less number of parameters error.

I hope it is clear to you.

Kindly let me know how can I get this.

Thanks and regards

Mohammad Azhar Siddiqui

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