hi everyone..

i am working on DB2 UDB.
I Need a stored procedure in db2 which accepts any number of arguements..

regards,

M.Sampath.

You cannot do it. What are you trying to do? Also give DB2 version and OS.

Andy

The Requirement is that when we pass any no. of arguements it should accept it.


The version is Db2 V 8.2
OS -- Linux

I understand your requirement even though it cannot be done. What I do not understand is what you want the SP to do. Maybe I can help with a work around.

Andy

The criteria is the when we pass some IN Parameter( i.e some table names) so if some changes are made to the tables ,I must be in a position to pas all the table names in a loop.

I hope u got my point.

sampath

No, I do not get your point. Please explain further. Perhaps some examples might help.

Andy

The only option that you have is to

1. not register the stored procedure, and
2. use the parameter style DB2DARI

The consequence is that you would have to call the procedure this way:
I'm not sure if V8 still supports that mode. The DB2DARI parameter style is no longer supported (except for applications that require it for backward compatibility).

What I would do in your situation is to use a single table whose rows will describe the parameters that influence your procedure logic. The procedure scan over the table and does whatever it should do.