How to Call a COBOL Stored Proc from REXX Module.

saurabh39 · Posted: Fri Feb 19, 2010 9:29 am

Hi All,

I am planning to create a REXX Exec to call and trap the result of COBOL Stored proc. I searched Net for this, but couldn't get enough material.

If anyone has any pointers regarding the same, please share with me.

Anuj Dhawan · Posted: Fri Feb 19, 2010 8:56 pm

I don't do REXX much - but if you know calling DB2 from REXX, your job is half done.

Check this related link: www.ibmmainframes.com/about38247.html and google on "rexx and db2" - you'll get some good pointers.

Anuj Dhawan · Posted: Fri Feb 19, 2010 8:58 pm

CHeck this one too Calling stored procedures from REXX.

Good Luck...

saurabh39 · Posted: Mon Feb 22, 2010 1:22 pm

Hi Anuj,

I have been to link provided in your mail. But it just say "The stored procedure can be written in any language supported on that server, except for REXX on AIX® systems. (Client applications may be written in REXX on AIX systems, but, as with other languages, they cannot call a stored procedure written in REXX on AIX.)" and nothing on REXX Exec to call SP.

AM I missing something?

Anuj Dhawan · Posted: Mon Feb 22, 2010 6:02 pm

I gave you a hint to get you going - please play around the link a bit...and there are some more links which might help you... have a look at this one www.redbooks.ibm.com/abstracts/sg247083.html?Open and this one publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_rexxsp.htm.

Go thorugh the above links and then in the REXX REFERENCE manual, Chapter 8.6, 'Summary of Writing Execs for Different Address Spaces',
there is a summary table listing the the REXX keyword instructions, built- in functions, TSO/E external functions, TSO/E REXX commands and other services you can use for execs that run in TSO/E and non-TSO/E address spaces.

You need to spend some of your time on these - I don't have something ready-made at this moment...