Joined: 14 Mar 2007 Posts: 8657 Location: Back in jolly old England
Perhaps for the non programmers amongst us, it may be beneficial to actually explain what the program will achieve.
Take a long long look at the information that you have given us. Not a lot there really, is there ? We only joke about being psychic, we're not really psychic much at all.
So, using my brain I have thought about what people might just need to know about the problem in hand.
1) What exactly it is that you want to achieve.
2) Examples of the the input records.
3) What is the expected output.
4) What are the RECFM and LRECL of the input files.
5) What is the RECFM and LRECL of any output files.
6) Where in each record layout is the compare / key fields.
7) How long are these fields.
8) What format do these fields use.
9) And most important of all, which sort product do you use, as the solution may vary from product to product, so why let someone waste time developing a solution for you which will not work because it is for the wrong product.
- The file1 LRECL is 400 and RECFM is FB. The file2 LRECL is 80 and RECFM is FB.
- Output LRECL is 80 and RECFM is FB.
- IN-KEY1 - Starting position 12, length 8 - from file1.
- IN-ACCT2 - Starting position 307, length 8 - from file1.
- IN-KEY2 - Starting position 50, length 8 - from file2.
- IN-KEY2 of file2 to be compared against IN-KEY1 and also IN-ACCT2 of file1 and unmatched value from file1 should be written to output file.
- The fields are character format.
- The product being used is Syncsort.