IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reading ESDS and updating KSDS


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Sep 10, 2011 6:28 pm
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

Moderator Emeritus


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

PostPosted: Sat Sep 10, 2011 9:46 pm
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

Superior Member


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

PostPosted: Tue Sep 20, 2011 2:55 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Random read in ESDS file by using RBA JCL & VSAM 6
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Updating a 1 byte thats in occurs mul... DFSORT/ICETOOL 6
Search our Forums:

Back to Top