Regarding DFSORT

a69356 · New User Joined: 01 Dec 2006 Posts: 21 Location: Gurgaon

Hi All,

There are two files let say A and B.

File A
field 1 Field 2
12345 XYZ

FILE B
field 1 Field 2
12345 ABC

I need to get an output file which have matching Field 1 and then need to add a character field X(02) whose constant value is CD.
I am doing it through Joinkeys which will match the records and put them in the third file.

dick scherrer · Posted: Tue Oct 26, 2010 7:55 pm

Hello,

Suggest you post a few more sample input records and the output youwant from those input records using the Code Tag.

Show what should happen when there is a match, when there is not a match, and when (if possible) duplicates.

Mention the dsorg and lrecl of the files.

Frank Yaeger · Posted: Tue Oct 26, 2010 8:23 pm

a69356,

You cannot use 6:2C'CD' in the REFORMAT statement. The syntax for REFORMAT is F1:p,m to include fields from file F1 and/or F2:p,m to include fields from F2. However, once you've used REFORMAT to create the joined record, you can use INREC, OUTREC or OUTFIL to further format it, e.g.