lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
Code: |
JOINKEYS FILE=F1
FIELDS=(001,020,A,
021,010,A
031,007,A,
038,010,A,
048,010,A)
JOINKEYS FILE=F2
FIELDS=(593,020,A,
081,010,A,
185,007,A,
140,010,A
012,010,A)
|
The field in file 1 (031,007,A) is comp-3 (PD) field whereas field in file 2 (185,007,A) is ZD. The matched records are not in output file. |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
These fields are not the same length, which is required by JOINKEYS.
Quote: |
The number of JOINKEYS fields and their lengths and sorted order (A or D) must be the
same for both files, although their starting positions need not be the same.
These fields will be treated as binary format for purposes of comparison during the match
processing. |
Possibly there is a way to reformat one of the fields before the JOINKEYS. . . |
|