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
This topic is locked: you cannot edit posts or make replies. Need help on If condition continuatio... ashok_uddaraju CLIST & REXX 4 Fri May 19, 2017 8:55 am
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Dump analysis of an assembler module monica1 PL/I & Assembler 4 Tue May 09, 2017 10:05 am
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am


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