Mass insert in DB2 using CICS.

Customer Information Control System. Middleware and MQ Series.
Post Reply
pravin kumar
Registered Member
Posts: 15
Joined: Wed Feb 19, 2014 6:17 am

Mass insert in DB2 using CICS.

Post 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.
User avatar
Anuj Dhawan
Founder
Posts: 2801
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: Mass insert in DB2 using CICS.

Post 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".
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
ggrcha
New Member
Posts: 2
Joined: Sun Jan 11, 2015 7:23 am

Re: Mass insert in DB2 using CICS.

Post 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.
pravin kumar
Registered Member
Posts: 15
Joined: Wed Feb 19, 2014 6:17 am

Re: Mass insert in DB2 using CICS.

Post 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?
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “CICS, Middleware and MQ Series.”