I have 2 files . One file is "|" delimited file where each record start with keyfield starting from column one. Second File is a error report which is fixed format file and the keyfield is starting from column 1 and end with column 10 ( key fields max length is 10 ) .Error Report also has header. Now I want to extract the records from file 1 which are unique to file 1 and not found in error report. I was planning to use SPLICE option but not sure as the format of the file is different. ( Error Report also contains a Header ) .
File 1 :
File 2 :
Customer Error Report 2008-08-05
345Dave Invalid Date
Could you please guide me how I can achive this output.
You need to do a better job of explaining the "rules" for getting from input to output. Which records and fields are you comparing in the two files exactly? What is the starting position, length and format of the fields in the fixed file? How do those fields relate to the corresponding fields in the delimited file? What is the length of the individual fields you're trying to compare between the fixed file and the delimited file?
A better example (with more records) of the input records and expected output records would also help. Use bbcode tags to make your example readable.
Also, what is the RECFM and LRECL of each input file.