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 IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm


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