Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?

Connecting COBOL stored procedure from JAVA without using MQ, Direct Call or by Webservice.

Posted on 2017-07-13
5
Medium Priority
?
52 Views
Last Modified: 2017-08-31
Hi All,

We are doing a small POC to migrate MF screens to JAVA based webpages. As a matter of fact, we have created COBOL SPs to call relevant MF DC online programs. In case we need to call COBOL SP, what approach do JAVA team has to follow.

NOTE : IBM MQ is not supported by customer
              IMS DC (IMS is the online component of my customer. IMS and DB2 databases are used by administration system) is not suggested as it needs additional work
              Webservice / business services help should not be used.

What could be the approach do we have to follow?

P.s : I am neither JAVA expert nor Mainframe expert. Since I am managing a project, trying to get suggestions from various areas.

Moreover I heard something like wrapping COBOL stored procedure with DB2 so that it can be converted to DB2 SP(Do we have any approaches like that). In my customer's IT landscape they can call DB2 SP by using ODBC driver.

I am looking forward to see responses from experts.

Regards,
Krishna
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 21

Expert Comment

by:Amitkumar Panchal
ID: 42217098
Hi Krishna,

Your question seems interesting to me as calling COBOL SP from Java is very rare use-case according to me (or at least i have never seen). So, i started googling around and found a documentation of Micro Focus Enterprise Test Server. They have provided an example for the same. I tried to download it (trial version) to explore more with the mentioned example, but no luck.

Refer below link (as well as attached snap).
http://documentation.microfocus.com/help/index.jsp?topic=%2Fcom.microfocus.eclipse.infocenter.edtest%2FHHQJCHJDBC04.html

ee-question.PNG
I hope the above will help you. But, lets wait for other experts to get in. They must have batter solution than mine.

Thanks,
Amit
0
 

Author Comment

by:Krishnamoorthy Athikesavan
ID: 42223124
Hi Amit,

Thanks for the suggestion. Now I am able to connect. The COBOL SP is actually stored in DB2(with appropriate schema name). Hence JAVA developers just used JDBC connectivity to call that SP.

One more thing to ask - This COBOL SP has calls to external COBOL program. Those cobol programs will execute SQL statements.
 
Can the external programs be IMS-DC online programs?  Why I am asking is, those IMS DC online programs are written in assembler and it is  quite complex. We are thinking of re-using those programs for our purpose. Can this be achieved?

JAVA --> COBOL SP(stored in DB2) ---> IMS DC online program(with calls to IMS & DB2 databases).

There is no CICS in landscape

Regards,
Krishna
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 42223392
Hi!

According to this you could make use of the DB2 external SP API to access COBOL SP/subroutines as well as Java SP and other DB2 native SP using the DB2 JDBC protocol. In fact, that would probably be your best solution to wrap it using Java as Java is zIIP offloadable. Note that not all of the workload would be zIIP offloadable though.
http://robertsdb2blog.blogspot.is/2014/10/db2-for-zos-stored-procedures-native.html
http://robertsdb2blog.blogspot.is/2014/05/db2-for-zos-some-matters-pertaining-to.html
http://www.ibmsystemsmag.com/Blogs/DB2utor/March-2016/DB2-11-Autonomous-Procedures/

Regards,
     Tomas Helgi
0
 

Author Comment

by:Krishnamoorthy Athikesavan
ID: 42230240
Thanks Tomas

DSNAIMS2 is the method to be used for my purpose. Will try it out and come back in case of any issues.

Regards,
krishna
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 42258416
Hi!

How did this turn out ?

Regards,
      Tomas Helgi
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Join & Write a Comment

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question