Calling DB2 program from a Non-DB2 program

raak · Posted: Tue Feb 06, 2007 11:08 am

Hi,

I am Calling DB2 program from a Non-DB2 cobol program. So in the JCL i think i should give the calling program's name in the EXEC PGM. Where should the Plan of DB2 program and Called program's name be specified? Should IKJEFT01 also be specified ?

ofer71 · Posted: Tue Feb 06, 2007 11:41 am

No, you can use EXEC PGM for the calling program; you must use DSN RUN with a TMP program (usually IKJEFT01).

You can always try CAF if you don't like the RUN method.

O.

mani_jnumca · New User Joined: 18 Jan 2006 Posts: 16 Location: PUNE

Hi ofer!!
can u elaborate more on this
i am unable to get it plzzzz

raak · Posted: Tue Feb 06, 2007 11:56 am

Hi Ofer

so in this case, r u saying that we need not give any pointer to the DB2 program? will the calling program take care of that ?

Is it possible to execute a DB2 program without pointing towards its Plan?

Bindu M · New User Joined: 09 Feb 2007 Posts: 4 Location: Madiwala

A normal Cobol program can always call a DB2 program, but job should have the plan of the Calling program though it is not a DB2 program

raak · Posted: Fri Feb 09, 2007 3:40 pm

Hi there,

I have got the answer for this. U should specify the IKJEFT01 in the EXEC PGM.

In the Sysin card, U have to give the Calling program's name along with the plan of the DB2program(called program).

Correct me if i am wrong.

ofer71 · Posted: Fri Feb 09, 2007 3:53 pm

I believe it's already been said above...

O.

Bindu M · New User Joined: 09 Feb 2007 Posts: 4 Location: Madiwala

Yes, you are right. But in Sysin card you have to give only the Calling programs name and not the DB2 programs(called program).