Archives of the TeradataForum

Message Posted: Thu, 19 Aug 2004 @ 14:44:10 GMT

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

Thank a lot Machael for the reply.

Let me tell u the need ..

I am trying out passing multiple values in one parameter declared in the macro part.For ex. EmpIDs like 1,2,3....but it is not accepting multiple values and throws an errors saying two many values.

     CREATE MACRO macroname(x integer)
     AS
     (
     SELECT
     fieldname
     FROM        DB.Tablename
     Where        fieldname In (:x)
     Order by fieldname;
     );

When I pass multiple values in the variable x , it throws an error. I need to know how can I pass multiple values, say for ex. multiple employee numbers to see records of them.I don't want to declare those many parameters..In other words make it dynamic.

Just like multi select prompts in any reporting tool wherein we can pass multiple values.

Hope you got what I want... if not then do let me know.. I would try to elaborate it further.

Thanks

Mohammad Azhar Siddiqui

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