Unanswered: db2 v8FP4 Win2kProf: Calling stored procedure from select query
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?