Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
I am using oorexx 4.1, XP SP3 DB2 Express-C 9.7.4.
I am executing a call from oorexx (using classic rexx) to the DB2 Stored
Procedure ADMIN_CMD LOADing a csv file into a table. The command itself is
working just fine and the table loads as expected.
v.sql = 'CALL SYSPROC.ADMIN_CMD('' ',
'LOAD FROM TEST.csv OF DEL ',
'METHOD P (1,2,3,5,6,7,8,9,10,11,12,13,14,15,16,18,19,20) ',
'INSERT INTO TEMP_TABLE ',
'(F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13, F14, F15, F16, F17,
'DATA BUFFER 4096 INDEXING MODE REBUILD''' ')'
call SQLEXEC 'EXECUTE IMMEDIATE :v.sql'
My problem is that the Stored Procedure returns as a dynamic result set, the
number of rows_read, rows_committed, rows_deleted etc etc. I need to be able
to read these values into variables. Now as far as I can tell, rexx does not
support the fetching of dynamic result sets as I have tried everything I know
to get these values and failed miserably.
Has anyone ever managed to do so and if so, PLEASE show me how ?
I have tried rexxsql to no avail as well. Even tried declaring cursors for
result set, have tried RXQUEUE but got nothing.
Because it is not a SELECT statement, it just seems like it is not supported
but as Dynamic Result Sets are common place, I would have thought it would be
a relatively straight forward process, presently however it's completely
beyond me how it is done.
Any help would be very gratefully received.
No one ? Any one at all ?
Well, so much for that I guess.