Krishnamoorthy Athikesavan
asked on
Connecting COBOL stored procedure from JAVA without using MQ, Direct Call or by Webservice.
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
DSNAIMS2 is the method to be used for my purpose. Will try it out and come back in case of any issues.
Regards,
krishna
Hi!
How did this turn out ?
Regards,
Tomas Helgi
How did this turn out ?
Regards,
Tomas Helgi
ASKER
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