Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Bulk Data entry in CICS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Suceender Kumar

New User


Joined: 10 Jan 2008
Posts: 29
Location: Chennai, India

PostPosted: Tue May 21, 2013 2:37 pm    Post subject: Bulk Data entry in CICS
Reply with quote

Hi,

We have a screen to enter employee details in online. Now another department employees were need to be added in our department. For example, in the other department we have around 500 employees were to be added here and we are finding a way to enter this data in our screen by means of some process instead of manual entry through screen.

I have come up with an idea of entering through a file. The data has to be stored in a VSAM file and this VSAM file will be after the Map RECEIVE command. So it will read sequentially and populate the map variable, process the data and loop until it process all the data. Then the SEND map will be triggered once all the data is processed. Any error by means of edit check will stop the process.
EXEC CICS RECEIVE
END-EXEC

EXEC CICS STARTBR FILE(….)
END-EXEC

EXEC CICS READNEXT FILE(…)
END-EXEC

……..
………
……..

EXEC CICS SEND MAP(….)
END-EXEC.

From READNEXT through before the SEND map will be in loop and the successful process of data in the input file will be deleted. So in a single transaction this BULK data will be uploaded. Is it a good way to do this?

Any other efficient way to achieve this?
Back to top
View user's profile Send private message

Stefan

Active User


Joined: 12 Jan 2006
Posts: 110
Location: Germany

PostPosted: Tue May 21, 2013 2:50 pm    Post subject: Re: Bulk Data entry in CICS
Reply with quote

Suceender Kumar wrote:
Is it a good way to do this?

NO
I assume the final outcome of your process will be set of employee data stored in a VSAM data set or DB2 tables which will include entries from the new department too. So why don't you populate the data store by technical means designed for these kind of bulk data processing? Create a batch job using REPRO (if it's a VSAM file) or a load utility like DSNUTILB (if it's a DB2 table).
NEVER EVER use an online transaction to do a mass update. Full stop.
Back to top
View user's profile Send private message
Suceender Kumar

New User


Joined: 10 Jan 2008
Posts: 29
Location: Chennai, India

PostPosted: Tue May 21, 2013 3:02 pm    Post subject:
Reply with quote

Finally it will store in DB2. The data has to pass some edit checks, cross reference from other tables and if the data passes all the edit check then only it has to store in DB2. It quite tricky in bringing the whole online process to batch. That’s why I am finding an alternate solution.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue May 21, 2013 4:04 pm    Post subject:
Reply with quote

You requirement doesnt explain much on what is actually needed and what you have done?

Also FYI CICS doesn't store data of files or tables

But just An Interface
Back to top
View user's profile Send private message
Suceender Kumar

New User


Joined: 10 Jan 2008
Posts: 29
Location: Chennai, India

PostPosted: Tue May 21, 2013 4:30 pm    Post subject:
Reply with quote

In Simple words, we need to add around 500 employee records through online screen, which passes through edit checks, cross reference tables and finally store it in a DB2 table. Since we have 500 records to be inserted, client finds it difficult to enter through screen. So is there any alternate solution available?
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue May 21, 2013 4:54 pm    Post subject:
Reply with quote

Pass the data to the copybook or commarea and call the CICS module throguh EXCI from Batch?

Or Try to recreate a Batch version of the CICS code to validate and load to DB2 (If time permits)

or Convert the data to vsam file format and read the VSAM file and process in CICS ?
Back to top
View user's profile Send private message
Suceender Kumar

New User


Joined: 10 Jan 2008
Posts: 29
Location: Chennai, India

PostPosted: Tue May 21, 2013 6:41 pm    Post subject:
Reply with quote

Quote:
Pass the data to the copybook or commarea and call the CICS module throguh EXCI from Batch?


Could you please provide some example or the document link for reference? I was not aware of this option.

Quote:
Try to recreate a Batch version of the CICS code to validate and load to DB2 (If time permits)


We have 14 screens like this to do and the time constraints

Quote:
Convert the data to vsam file format and read the VSAM file and process in CICS ?


This was the option i was trying to explain in my initial message. By storing the data in VSAM file and populating the variables.

Thanks for all your inputs.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue May 21, 2013 6:53 pm    Post subject:
Reply with quote

Check here
and here
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 21, 2013 10:10 pm    Post subject:
Reply with quote

Hello,

Quote:
It quite tricky in bringing the whole online process to batch. That’s why I am finding an alternate solution.
To do what you want/need, there is no reason to bring the "whole online process" to batch.

I believe you have more than this alternative.

One way would be to do as suggested and use EXCI to invoke CICS code.

Another would be to copy the data to a sequential file, edit it by cloning the online edits to bacth code (also suggestes) or possibly using Sort to edit (depends on complexity), and format the data for loading directly into DB2.
Back to top
View user's profile Send private message
Suceender Kumar

New User


Joined: 10 Jan 2008
Posts: 29
Location: Chennai, India

PostPosted: Wed May 22, 2013 10:01 am    Post subject: Reply to: Bulk Data entry in CICS
Reply with quote

Thanks everyone for the valuable inputs!!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 1 Tue Dec 06, 2016 4:38 am
No new posts How to move a long alphanumeric data ... lind sh COBOL Programming 6 Mon Dec 05, 2016 7:51 pm
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us