Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us