Page 1 of 1
Mass insert in DB2 using CICS.
Posted: Tue Sep 09, 2014 12:29 pm
by pravin kumar
Hi,
As we have multi-row insert available in batch jobs, do we have something similar available in CICS? I also want to understand that if it's available then is it advisable to use it as CICS is mainly for real-time use then allowing a mass insert will be of what use?
Thanks for your help in this regard.
Re: Mass insert in DB2 using CICS.
Posted: Sat Sep 27, 2014 9:18 am
by Anuj Dhawan
I'm not sure about DB2, however, if you look at this link
http://pic.dhe.ibm.com/infocenter/cicst ... write.html and search for MASSINSERT - it gives you details about 'multi-row-insert about VSAM".
Re: Mass insert in DB2 using CICS.
Posted: Sat Jan 17, 2015 4:11 pm
by ggrcha
Thay'a a very interesting discussion, and we should use many info to support our arguments, but in short terms: any non-conversational work or any work that do not have an user (or terminal) waiting for a response should run outside CICS.
Re: Mass insert in DB2 using CICS.
Posted: Sat Jan 17, 2015 7:06 pm
by pravin kumar
ggrcha wrote:Thay'a a very interesting discussion, and we should use many info to support our arguments, but in short terms: any non-conversational work or any work that do not have an user (or terminal) waiting for a response should run outside CICS.
That is is correct but can we really do mass insert in DB2 through a COBOL CICS program?