Passing record sets to DB2 stored procs

deepak.pandit · #1 (**permalink**) 04-01-06, 05:54

Hi all,

Can we pass record sets as input parameters to SQL stored procedures?

Thanks and regards,
Deepak

bala_e · #2 (**permalink**) 04-03-06, 00:52

Quote:

Originally Posted by deepak.pandit

Hi all,

Can we pass record sets as input parameters to SQL stored procedures?

Thanks and regards,
Deepak

Yes, u can pass with column delimiter and record delimiter.

sathyaram_s · #3 (**permalink**) 04-03-06, 03:15

You can INSERT the reocrds into a Declared Global Temp table before calling the SP and read the records inside the SP

HTH

Sathyaram

Quote:

Originally Posted by deepak.pandit

Hi all,

Can we pass record sets as input parameters to SQL stored procedures?

Thanks and regards,
Deepak