The Join Logical has 5 tables and 3 Omits. We changed one of the Omits to a Select and flipped the logic. Now it seems to be working.
The original code for the Omit logic in the DDS for the Join looked like this:
A O FLDC1 CMP(EQ 'Y')
A O FLBC2 CMP(EQ 'Y')
A O FLDA3 CMP(EQ 'Y')
Changing to ...
A O UICRPL CMP(EQ 'Y')
A O UIBRPL CMP(EQ 'Y')
A S UIARPL CMP(NE 'Y')
Thanks for all of the feedback.
This communication, including attachments, is confidential, may be subject to legal privileges, and is intended for the sole use of the addressee. Any use, duplication, disclosure or dissemination of this communication, other than by the addressee, is prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy this communication and all copies.
This mailing list archive is Copyright 1997-2019 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