Suppose we have a line-item file, and a part master file.
The line item records have a part number. And it cross-references to the
part master file.
But if a given part is stocked in two or more warehouses, then the part
master file has a record for it at each warehouse that stocks it.
Now, suppose we have a join between the line item file and the part
master file, on the part number. For each line item, the join is
returning a record for every matching part master record.
Not especially good. Is there a way, that works in DB2/400, to limit
that to only one join record per line item? And to select, for example,
the one with the low value in the "lead time" field?
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
