Hi folks,

I am using Classic Rexx 4.1 calling the SYSPROC.ADMIN_CMD command to LOAD data into table. The command appears to be working fine, but I need to be able to read the output from the SP to get the number of rows read, skipped, loaded, rejected, deleted, committed etc which is the output returned by the SP.

I have tried all manner of ways trying to retrieve the data but it simply will not work for whatever reason. Can some kind soul please advise how I get classic oorexx 4.1.0 to read a dynamic result set from DB2 Express-C 9.7.4 the SYSPROC.ADMIN_CMD stored procedure ?

I am calling the SP via :

call SQLEXEC 'EXECUTE IMMEDIATE :v.sql'

Many thanks, Fin

Nobody ? Anybody ? .. I'm begging here .. heh Desperate !

On 18.07.11 23:49 , Fin wrote:
Sorry, haven't used Rexx for more than 10 years...

I really loved that language (walking down memory lane). If I had a problem
with Rexx, I'd contact the developers/designers of Rexx.
They wrote the binding of values, so they should know for sure.

(I am one of the original developers of the native DB2 driver for PHP, so
shoot away, if you have any questions there... :-))

--
Helmut K. C. Tessarek
DB2 Performance and Development
IBM Toronto Lab