I have a question related to COBOL DB2 program in two different application.
I have a COBOL program (PGM-A) which belongs to Application-1. This program requires some data from Application-2. PGM-A calls to PGM-B (COBOL module). PGM-B calls to PGM-C(COBOL + DB2 module). PGM-B and PGM-C belongs to Application-2.
PGM-C gets the data from application-2 database(DB2) and pass it back to PGM-B and PGM-B then forwards it to PGM-A.
1. When PGM-A doesnt have authority to access Application-2 database, how its gets the data.
2. How can we restrict PGM-A accessing data from Application-2.
3. When PGM-A is being invoked from JCL, do we need to pass IKJEFTO1 inputs (program, plan) etc or it can be invoked directly by PGM=PGM-A
Basically you need to add into PGM-A commands CONNECT ssid and OPEN plan calls. Also don't forget CLOSE and DISCONNECT The way how you pass these parameters (ssid/plan) to your application is up to you.