AS400 Flat file data comparison on Window based third party tool like Examdiff Pro

350 pts.
Tags:
AS/400 Data File
AS/400 Data Reports
AS/400 flat file
My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files.

 example Original flat file 1 :

 HDRINTT BKGS300 E2011020711 ID PCABBDL00 PNACHIW RFGTUSOAK0222516 RFINUSOAK0222516 RFBKPCABBDL00

received revised flat file : HDRINTT BKGS300 E2011020711 ID PCABBDL00 SNACHIW RFGTUSOAK0222516 RFINUSOAK0222516 RFBKPCABBDL00

so SNACHIW is new value at ID level . PNACHIW shud be updated with SNACHIW.

differences shud be highlighed in Comparison tool so that use can ignore and update changes.

Plz suggest the way to proceed. My system gets data in flat file



Software/Hardware used:
AS400
ASKED: February 22, 2011  11:07 AM
UPDATED: February 28, 2011  1:21 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    I have to compare both flat files data in window based comparison tool like EXamdiff Pro . Is there a reason that you can't use "EXamdiff Pro"? Plz suggest the way to proceed. Are you looking for recommendations other than "EXamdiff Pro"? What kind of answer are you trying to get? Tom
    125,585 pointsBadges:
    report
  • Kapiltiwari
    Tom, Actually i want to know how to browse AS400 flat files into Examdiff Pro ? and how to save changes again to AS400 by ExamDiff Pro? Is there any way so that i can open flat files of any lib by Examdiff Pro.?
    350 pointsBadges:
    report
  • Kapiltiwari
    One more thing , is it possible to run exe of this tool automatically on window with having data of File1 and File2 by as400 program on the basis of condition that is True if File 2 has changes for File1.
    350 pointsBadges:
    report
  • Kapiltiwari
    No body is suggesting me. Is this requirement is not feasible?
    350 pointsBadges:
    report
  • Kapiltiwari
    Mr. Tom u were about to tell me something
    350 pointsBadges:
    report
  • DanTheDane
    No wonder that you get no answers... Your request for help is very unprecise. If you can be more specific, I believe that you will get your dialog and solution. From your request, I fx wonder on 1. If the two files resides on your AS/400, why then use a pc-tool ?? 2. Is EXamdiff Pro a must; - if yes pls explain why. 3. does the comparizon and update require human interaction ? 4. Are every incoming file kept as a file of its own for your application, or are the in-files data places as records in a cumulative file ? 5. What part of the incoming data is used to find the corresponding data that is to be updated ? - pls explain 'ID level'. I once created a booking solution which had the following elements: a. booking file with one ore more bookings recieved b. data automatically checked up against a cumulative file with all current bookings (we had a unique key (bookingno), and one of two processes were chosen: b1. If key not found in cumulative file, the incoming record was added to it, and some business processes were run automatically. b2. If key found in cumulative file, this new incoming record was added to a file used by an interactive application, from which operator could decide and initiate some proces. To me, it looks like that you should drop the EXamdiff Pro solution, and create a small native AS400 app !! I hope you will comment on my above 5 'wonders' so we have a chance to help you. rgds DanF
    2,555 pointsBadges:
    report
  • Kapiltiwari
    thanks , plz find the ans of wonders. 1. It is one of the ways suggested by the client. I have both files on AS400. I get flat files with starting level header (HDR) . HEADER DOCUMENT REFERENCES PARTY IDENTIFIER ADDRESS GEOGRAPHIC LOCATION CONTACT PORTS TRANSPORT EQUIPMENT - SUMMARY EQUIPMENT SETTING - SUMMARY EQUIPMENT EXTRA MEASURES - SUMMARY SURCHARGES etc. all above represent one row in flat file .every row contains different values. these level rows can be multiple. example ITM may be 1 or 2 or 3 or 5... etc. so rows starting with ITM level must be multiple. HDR ttttt kapil BKGS300 E 201102071122000003 DOC ......................................... REF ........................................ PID ........................................ ADR..................................... header row contains value compny name ,customer name,type of msg,date and time etc. same every level has multiple values. 2. No, EXamdiff Pro is not necessary. 3. Yes , comparison needs user interaction . Opt field Original Revised Status (Ignored ,uploaded ,pending) __ Consinee name P.P. ship K.K. Ship uploaded __ Port code __ Port schedule __ Terminal name this screen has been suggested in AS/400. But it is tough to maintain every value status in file and and showing every time to user this comparion after reading original data (uploaded to finally booking file,address file,Item file).What kind of structure of that file wud be that maintain history of status(ignored/pending/uploaded) where every row of flat file having different multiple values. and every value can have any status. 4. if the booking is confirmed , we upload the data into columns based physical file like booking file,itm file,customer address file .if customer send the revised EDI msg for booking. that msg must contain booking that is already given to customer once previous boking data is uploaded.tghis way we find this is new booking or revised. 5. booking number is unique . Your suggestion is right to drop the EXamdiff Pro solution but i thought just compare the files and highlight the differences rather than going to specific to value level. i hope this wud clear the image of my requirement.
    350 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following