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) ',
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.
Tim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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,
F18) ',
'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.
Tim
No one ? Any one at all ?
Well, so much for that I guess.