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

KSDS dataset Key correction using Easytrive


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Vinodc

New User


Joined: 01 Dec 2005
Posts: 33
Location: Prague

PostPosted: Wed Mar 01, 2006 4:07 am
Reply with quote

Hi,

I know spelling of Easytrive, and thats only thing I know about it. But I have a requirement that somebody told me can be easily solved by it. I can do the same using cobol, but I dont have that much time. So any fast help will be appreciated.

My requirement is to correct data in a VSAM KSDS file. Its key is:
05 XXX_Account Number PIC 9(19) Comp-3.
05 XXX_Date PIC 9(8) Comp-3.
05 XXX_Time PIC 9(7) Comp-3.

The file contains tens of thousands of records, and quite a few of them have incorrect time value.

So the logic should be:
Read record from input file sequentially,
if time is correct, write same record in output file of same format.
if time is incorrect, correct time and write the record in output.

Thanks in advance.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Wed Mar 01, 2006 4:33 am
Reply with quote

Vinodc,

You might also want to post this in the VSAM & DFSORT forum. Could be that Frank may have a DFSORT solution. DFSORT is a powerful tool and I'm impressed with how many problems Frank can come up with a DFSORT solution to.

If you post this in the VSAM & DFSORT forum, give a little more information on what the time should be, and what how to distinguish an incorrect time.

Dave
Back to top
View user's profile Send private message
Vinodc

New User


Joined: 01 Dec 2005
Posts: 33
Location: Prague

PostPosted: Wed Mar 01, 2006 5:05 am
Reply with quote

Hi DavidatK,

Thanks for advice. Well for me as of now what matters most is the solution, anyhow and as soon as possible. May it be using easytrive or DFSORT.

So I have a post at VSAM & DFSORT forum too... http://ibmmainframes.com/viewtopic.php?p=32989#32989

Now waiting for Frank's attention on it.
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 -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top