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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm


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