Where are you seeing the example in the documentation?
The easiest way to avoid trouble is: never do more than a 2 way file sync in Easytrieve. 1 or 2 file syncs are easy to understand and work with. I've been coding Easytrieve since even before it was Easytrieve Plus. I have *never* done a 3 file sync. I use multiple activities*, for example if I have 3 files, I sync 2 in one activity to create a virtual file, then sync that to the 3rd file in another activity. * but we've learned that multiple activities is not a good practice for production cycle jobs. -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Pierre Fichaud Sent: Tuesday, November 7, 2023 9:00 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Easytrieve Synchronized File Processing (SFP) I'm looking at the doc on this and the rules on how it works are not clear. I would appreciate the help of an expert on this. The doc has an example of 3 files and it shows each iteration in the processing and which files are "available" or N/A. File 1 key 3A is available twice - iterations 3 and 4. File 1 key 8A is available twice - iterations 11 and 12. My impression is that records with equal keys are available from innermost to outermost until a duplicate key is encountered. The simplest case is a 3-way merge to produce a completely sorted file. If a record is "available" twice, one needs to remember this and not process the record the 2nd time it is available. This isn't too bad for a 3-way merge but it gets more complicated as you add files. " Remember, the matching algorithm is hierarchical, so the key is exhausted on the lowest level before another record is processed from the next higher-level file." - This is from the documentation. This statement contradicts what happens in the table of iterations shown in the documentation. Please contact me offline. Regards, Pierre. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
