MVSFORUMS.com

tholkappian

I have to call a CICS program from a DB2 Stored Procedure through EXCI. I am passing a huge amount of data coz of which am using a temp table and not the COMMAREA. The session has to be maintained through out the process for the CICS programs to access the temp table. Will the session be maintained in the CICS programs? Or will a new session be created when I call them using EXCI?
Thanx in advance
Rolling Eyes

kolusu · Posted: Thu Jun 09, 2005 1:11 pm Post subject:

tholkappian,

Read chapter 7 in the following link ( you can choose PDF or html version of the manual) which will answer your queries

http://publib-b.boulder.ibm.com/Redbooks.nsf/0/a73b5f113115fb4b882568d4005ddde3?OpenDocument

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

tholkappian · Posted: Fri Jun 10, 2005 4:42 am Post subject:

Thanks a lot.... But still this document does not provide me details about using a temporary table between the stored procedure and the CICS programs. I need to know whether temp tables can be used as a medium to pass and receive data? Can i access the temporary table created and loaded in the stored procedure from the CICS program ?

Thanks in Advance..