Join Logical - How To Prevent Duplicate Records

[JohnBates]

Hi,

I'm joining 3 physical files.

Files 1 and 2 have 1-to-1 data There is only 1 rec in File 2 for the matching rec in File 1.

But File 3 is Order Detail - so it can have multiple records for an Order Number.

The Join view I've created contains duplicate records.

For example Order # 1 requires a qty of 84 for Model A
and a qty of 42 for Model B....

but the join file contains 4 records for this order:
84, 42, 84, 42



I've tried rearranging the order of the files on the JFILE and JFLD specs.... always get duplicate recs in the view.

Tried the UNIQUE keyword, but with no luck.

Any ideas?

Thanks, John

 

[iSeriesCodePoet]

I would double check your keys, you might be missing one.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[RedMage1967]

In your join file, are you using the keyword JDFTVAL?

RedMage1967
IBM Certifed - RPG IV Progammer

 

[JohnBates]

RedMage1967,

"In your join file, are you using the keyword JDFTVAL? "

yes. Is that causing the dup recs?

I'll remove it tomorrow when I get to the office.
Thanks for the suggestion. John

 

[RedMage1967]

It's been a while since I've used join files. I do believe there is a keyword called JDUPSEQ. Might want to check that keyword out as well.

RedMage1967
IBM Certifed - RPG IV Progammer