hi all,
i have below req.
I have input file1and input file2. input file1 has paried records means each record (lrec of 160) is divided into two small records (lrec 80, showed with part1 and part2),indicated by 2 and 3 at col# 1 in below example. Key starts at col# 8 of length 4 and Key is present only in the first part of the small record.
e.g: let
file1: FB, LREC=80,
2 qwer 1111 qw (part1)
3 nn1 00 00 (part2)
2 qwer 1112 qw (part1)
3 nn2 00 00 (part2)
2 qwer 1113 qw (part1)
3 nn3 00 00( part2)
2 qwer 1114 qw (part1)
3 nn4 00 00 (part2)
P.S: part1 and part2 are not part of the records. just for sake of understanding that part1 and part2 constitute of one record.
file2: FB, 80
1111
1114
so when join/splice file1 and file2 the output should contain only unparied records of File1.
output file FB, 80 and it should be,
2 qwer 1112 qw
3 nn2 00 00
2 qwer 1113 qw
3 nn3 00 00
the below records should not be in the output as its key matches with file2
2 qwer 1111 qw
3 nn1 00 00
2 qwer 1114 qw
3 nn4 00 00
can it be done in SORT using SPLICE/JOIN ?? Thanks!