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
 

 

Reading ESDS and updating KSDS

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

New User


Joined: 28 Feb 2006
Posts: 1
Location: Delhi

PostPosted: Sat Sep 10, 2011 5:29 pm    Post subject: Reading ESDS and updating KSDS
Reply with quote

Hi, please suggest on below.

I've a KSDS file where Phone Number is the key and there are various other fields including Customer Name. In Customer Name field we have special characters which business wants to correct. Now there will be an ESDS file (as input file) wherein we will have only two fields - phone number and their corresponding 'valid' Customer Names.

We have to do this using an online program/transaction which we'll trigger only once. I am new to online programs. Would appreciate if anyone could advice what approach to follow. Thanks!

Thanks and regards,
Aby
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Sat Sep 10, 2011 6:28 pm    Post subject: Reply to: Reading ESDS and updating KSDS
Reply with quote

Can you clarify what it has to be an online program?

It is much easier to write a one-off batch program than a one-off CICS program (I've never heard of a one-off online program!). There's all the stuff you'd need to define for CICS then, presumably, take it all out again after successful completion - or will it be a periodic thing?

I expect CICS is using the KSDS, but that the ESDS is new? Even if you are 24/7, presumably a "maintenance window" is a possibility?

To me the requirement screams "batch". Simple processing, produce audit report with name before/after, number of changes, number of keys not found (you never know), number of change records read, business date, run date, time.

Out of interest, is there really no possibility of requiring the same telephone number for more than one client? Different members of same household, different members of same company without a fancy switchboard, telephone in student halls-of-residence? Lucky you, maybe they are all cell-phones.
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: Sat Sep 10, 2011 9:46 pm    Post subject:
Reply with quote

Hello and welcome to the forum,

Quote:
We have to do this using an online program/transaction which we'll trigger only once.
This is surely not a business requirement. . .

Quote:
It is much easier to write a one-off batch program than a one-off CICS program (I've never heard of a one-off online program!)
Yup, batch would be a better choice. What some of my clients have done is to assign a few transaction-ids for one-off situations. These are enabled and disabled after the one run. The source has separate names, but when used, they are set up as one of the one-time-shot transactoins.

Have you considered how this is to be initiated? One way could be to initialte the online transaction from a batch job.

There must be some time when the online is down (i.e. to run backups or run the normal batch processes. This one-off could be scheduled for one of the batch windows. . .
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 20, 2011 2:55 pm    Post subject:
Reply with quote

We had been involved in a similar problem once and I agree with Bill and Dick - Batch process was the preferred way, among many others.
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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Need help in reading and validating a... ABINAYATHULASI COBOL Programming 8 Tue Apr 18, 2017 11:42 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am


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