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: 7251

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 Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Reading data from PS file and send it... rajatbagga All Other Mainframe Topics 18 Fri Sep 23, 2016 12:51 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
This topic is locked: you cannot edit posts or make replies. Updating value of key using rewrite s... ParminderKumar COBOL Programming 4 Thu Aug 04, 2016 12:46 am


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