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.

Close

DB2 Stored Procedure Dynamic Result Sets

Help
Tim.D
2011-07-24
2012-08-14
  • Tim.D
    Tim.D
    2011-07-24

    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

     
  • Tim.D
    Tim.D
    2011-07-27

    No one ? Any one at all ?

     
  • Tim.D
    Tim.D
    2011-07-31

    Well, so much for that I guess.