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
 

 

KSDS dataset Key correction using Easytrive

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: KSDS dataset Key correction using Easytrive
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    Post subject: Re: KSDS dataset Key correction using Easytrive
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    Post subject: KSDS dataset Key correction using Easytrive
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    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Easytrive Redefine vidyaa CA Products 4 Mon Jun 19, 2017 6:01 pm
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am


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