Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to Call a COBOL Stored Proc from REXX Module.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
saurabh39
Warnings : 1

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Fri Feb 19, 2010 9:29 am    Post subject: How to Call a COBOL Stored Proc from REXX Module.
Reply with quote

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.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Feb 19, 2010 8:56 pm    Post subject:
Reply with quote

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

Check this related link: http://www.ibmmainframes.com/about38247.html and google on "rexx and db2" - you'll get some good pointers.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Feb 19, 2010 8:58 pm    Post subject:
Reply with quote

CHeck this one too Calling stored procedures from REXX.

Good Luck...icon_smile.gif
Back to top
View user's profile Send private message
saurabh39
Warnings : 1

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Mon Feb 22, 2010 1:22 pm    Post subject: Reply to: How to Call a COBOL Stored Proc from REXX Module.
Reply with quote

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?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Feb 22, 2010 6:02 pm    Post subject:
Reply with quote

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 http://www.redbooks.ibm.com/abstracts/sg247083.html?Open and this one http://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...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts RULES(NOEVENPACK) in cobol jackzhang75 COBOL Programming 5 Wed Mar 29, 2017 12:47 am
No new posts REXX cdoe to purge a JOB from spool a... Sulabh Agrawal CLIST & REXX 11 Thu Mar 09, 2017 11:36 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us