Hi All,

Yet another problem. I am running db2 version 8 fix pack 4 on win2k prof machine. I am porting Oracle database to db2. I had to convert several functions to db2 procedures because of the limitations with cursors, error handling, modifies sql data etc. Now I have to call a stored procedure in a query like:

select fld1, procedure1(param1, param2, outParam3) as/into fld2 from tableName
How can I do this?


Regards,
Deepak Ajmera

Deepak,
You cannot. It is not allowed.

Andy

you can not cal procedure from SELECT statement , function can be called

He could put the SQL in an SP and call the other SP from there to set his parameter. There should be a few example of this on this forum.

Thank you for your replies...

Regards
Deepak Ajmera