Non Db2 calls Db2 , how to run ?

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
need@help
Member
Posts: 2
Joined: Fri Feb 27, 2009 12:36 am

Non Db2 calls Db2 , how to run ?

Post by need@help » Fri Feb 27, 2009 12:47 am

Hi ,

Can someone please help me with this query :

I have a non DB2 cobol module P1 which is calling a DB2 module P2 , to run P1 what should be the JCL . I did some research on this forum and it seems we need to use TSO command and same jcl which is needed for db2 program to run P1 .Prog name will be P1 , the PLan should consist P2 . do we need P1 also in the plan ? is it possible to bind a non db2 module to plan .

Can someone who has pratical experience of such situation please explain it to me with jcl details .

Thanks!

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Fri Feb 27, 2009 10:43 am

I never tried this... but i got info from my friend .... please try.

We dont required P1 on the plan.

use the following card while running these modules.

DSN SYSTEM(<your database system>)
RUN PROGRAM(Non-DB2 Program) PLAN(calling db2 module name)
END
Natarajan
Chennai

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others