Hi,
My input is
AAAA111 12
BBBB222 13
CCCC333 14
and
DDDD444 15
EEEE555 16
FFFF666 17
My output should be
AAAA111 12
BBBB222 13
CCCC333 14
DDDD444 .. 15
EEEE555 .. 16
FFFF666 .. 17
I used sort card as below
//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(01,07,A)
JOINKEYS FILES=F2,FIELDS=(01,07,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:1,10,F2:1,12),FILL=X'FF'
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=(01,10,BI,EQ,X'FF'),BUILD=(8,7))
/*
and I got the output as
AAAA111 12
BBBB222 13
CCCC333 14
.............. DDDD444 15
...............EEEE555 16
...............FFFF666 17
How can i get the expected result? Please help