MVSFORUMS.com

sri50131 · Beginner Joined: 07 Oct 2004 Posts: 38 Topics: 15

Hello,

I have a non-DB2 program that is a driver program. This program calls a DB2 program and several other non-DB2 programs. In my JCL, I have a DSN Run command to run the DB2 program. How do I code IKJEFT1B in my JCL or rather where excatly do I have to put it?. I am executing the driver program by coding EXEC PGM=DRIVERPGM. To execute the DB2 program, I added another step to execute IKJEFT1B followed by the DSN Run command. The Job is abending with SQLCODE=-927.

Thanks,
Sri

kolusu · Posted: Wed Oct 13, 2004 5:10 pm Post subject:

Sri50131,

Create a Plan for the Main program and invoke the Main program from IKJEFT01

sri50131 · Beginner Joined: 07 Oct 2004 Posts: 38 Topics: 15

Kolusu,

I did want you said:

In the JCL, I am now calling the main program using the RUN PROGRAM, instead of EXEC PGM=mainpgm. I am still getting the same
SQLCODE=-927,when the driver program calls the DB2 pgm. What am I missing?

My question to you is
(i) How do I compile my main program, with DB2 options or without it. I guess, I have to do without DB2 options.
(ii) Do I have to have another RUN PROGRAM for the called DB2 program in my JCL. If so, do I have another step for the DB2 program and does this step need to be before I call the driver program.

Thanks.

Bithead · Posted: Thu Oct 14, 2004 12:04 pm Post subject:

You can compile your main program withoput DB2 but you will need to bind your subroutine and use this as the name of your DB2PLAN.

Cogito-Ergo-Sum · Posted: Thu Oct 14, 2004 3:06 pm Post subject:

SQLCODE=-927 stands for

Cogito-Ergo-Sum · Posted: Thu Oct 14, 2004 3:07 pm Post subject:

Uh oh!

The code block should read INCLUDE SYSLIB(DSNELI).
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

Bithead · Posted: Thu Oct 14, 2004 3:10 pm Post subject:

Thanks. You were confusing me!