ranga_subham wrote:Why does it fail if I use JOIN UNPAIRED,F1 but goes through when JOIN UNPAIRED,F1,ONLY used.
What is the meaning of JOIN UNPAIRED,F1 & REFORMAT FIELDS combination?
JOIN UNPAIRED,F1,ONLY indicates that you only want the unpaired records from SORTJNF1, not the paired/matched records.
JOIN UNPAIRED,F1 indicates that you want the paired records AND the unpaired records from SORTJNF1 (but not the unpaired records from SORTJNF2).
The REFORMAT statement specifies which fields from SORTJNF1 and SORTJNF2 are to be included in each record created by the JOIN processing.
When both JOIN UNPAIRED,F1 and the REFORMAT statement are specified, any fields not present will be filled with blanks* (X'40') by default.
*This can be changed by coding the FILL=f subparameter (where f specifies the fill byte) on the REFORMAT statement.