Static Subroutine for CICS and BAtch programs

ravindra.ap · New User Joined: 18 Jul 2011 Posts: 3 Location: UK

We have scenario where we need to fetch the data from oracle, we had written a static subroutine which as Exec CICS call to call a CICS program and that CICS program has got HTTPS call to fetch the data from oracle (refer attachement for the daiagram
). Can structure is defined in the below diagram,

Problem we are facing is that static subroutine being called by both Batch programs and online programs . Our batch program will execute fine when we use the below load libraries in the batch JCLs,
SYSCICSX.OX0CICS.V620.SDFHEXCI.B
SYSCICSX.OX0CICS.V620/V650.SDFHCOB.B
SYS1.SCEELKED
SYS1.SCEERUN

But our online CICS programs are failing with error message 'CSV003I REQUESTED MODULE DFHXCPRX NOT FOUND'.

Could you please advise if we include above load libraries to the CICS job will the CICS program goes fine? Any other solution to get the above requirement achieved will be much helpful and appreciated.

Many thanks in advance for your help.

expat · Posted: Mon Jul 18, 2011 9:24 pm

You need to speak to your own site support for site specific problems.

What if I said "yes, no problems" and you then procede to wipe out a load of production data.

Bill O'Boyle · Posted: Mon Jul 18, 2011 9:41 pm

Why as you issuing an EXCI LINK from a native CICS program?

EXCI is used to issue a DPL (Distributed Program Link) from Batch (The Client) to CICS (The Server).

You should be able to access Oracle directly from CICS without the need of EXCI or ECI for that matter.

The Oracle folks should supply with an interface and/or instructions on how to write an interface.

Bill

Bill Woodger · Posted: Tue Jul 19, 2011 1:15 am

There's an old topic which might be worth you reading
ibmmainframes.com/about50376.html