Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Calling DB2 program from a Non-DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
raak

Active User


Joined: 23 May 2006
Posts: 166
Location: chennai

PostPosted: Tue Feb 06, 2007 11:08 am    Post subject: Calling DB2 program from a Non-DB2 program
Reply with quote

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 ?
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Feb 06, 2007 11:41 am    Post subject:
Reply with quote

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. icon_wink.gif
O.
Back to top
View user's profile Send private message
mani_jnumca

New User


Joined: 18 Jan 2006
Posts: 16
Location: PUNE

PostPosted: Tue Feb 06, 2007 11:55 am    Post subject: Re: Calling DB2 program from a Non-DB2 program
Reply with quote

Hi ofer!!
can u elaborate more on this
i am unable to get it plzzzz
Back to top
View user's profile Send private message
raak

Active User


Joined: 23 May 2006
Posts: 166
Location: chennai

PostPosted: Tue Feb 06, 2007 11:56 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
Bindu M

New User


Joined: 09 Feb 2007
Posts: 4
Location: Madiwala

PostPosted: Fri Feb 09, 2007 12:37 pm    Post subject: Re: Calling DB2 program from a Non-DB2 program
Reply with quote



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 icon_exclaim.gif
Back to top
View user's profile Send private message
raak

Active User


Joined: 23 May 2006
Posts: 166
Location: chennai

PostPosted: Fri Feb 09, 2007 3:40 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Fri Feb 09, 2007 3:53 pm    Post subject:
Reply with quote

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

O.
Back to top
View user's profile Send private message
Bindu M

New User


Joined: 09 Feb 2007
Posts: 4
Location: Madiwala

PostPosted: Sat Feb 10, 2007 6:16 pm    Post subject:
Reply with quote

Yes, you are right. But in Sysin card you have to give only the Calling programs name and not the DB2 programs(called program).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us