tpayne
Reputable Poster
I need to select records on a DW version where the value of one field is equal to another. Since DW encompasses much of the OPNQRYF functionality I would hope that you could do this, but I can't figure out a way to do it.
In this case I want to only select records from the address book where the Main Address (ABAN8) is equal to the Factor Address (ABAN85). If I just try to put the ABAN85 field name in the selection area anywhere it gets prefixed by '00' (00ABAN85) which does not work.
Any ideas?
Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516
In this case I want to only select records from the address book where the Main Address (ABAN8) is equal to the Factor Address (ABAN85). If I just try to put the ABAN85 field name in the selection area anywhere it gets prefixed by '00' (00ABAN85) which does not work.
Any ideas?
Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516