Mulit Select Parameter to the DB2 Procedure from IReports

[ravikirank]

 Hi 

I have a requirement of sending multiple values to the db2 procedure.

I tried to use the Java.Util.Collection in the Add parameter options and used $X{paramter} in the Where clause of the procedure call.

In Query if I use

 

select * from test where  $X{ IN ,v_name,MyParam}

but when I use the same in the procedure it will not allow. So how to pass multiple parameter list to a db2 procedure from iReports ?

call  USP_SAMPLE $X{ IN ,v_name,MyParam}

the above statement did not work. and gives and error message.

 

Regards

Ravi

[yzhou]

Ravi,

 

I have same issue except we call the stored procedure in MSSQL. Have you got any solution?

 

Let me repeat the question:

 

In the report, a SQL procedure is expecting a parameter in SQL Text type, such as "abc, de, fg". The paramete in report should be java.util.List, so allow user from a multi-selection dropdown. What is correct syntax to use the List parameter in procedure call?

 

Thanks,

 

Yejin

 

 

[ADR707]

Any Solution to Ravi's issue

I'm facing the same issue myself.

How to use the parameter of collection type in ireports using DB2 database,

where

(case

when ('a' = 'a') then $X{ IN ,col1,MyParam}

when ('a' = 'b') then $X{ IN ,col2,MyParam}

end)

gives error!!!!!!

 

Please help,

Thanks & Regards,

Sam

 

Post Edited by asksam55 at 03/22/2012 10:51