My program is supposed to accept an input which may be found in either of two fields in a PF and I need to display all records where the input is in either fields.
For example:
The user enters a value, say ORD12.
I have a cross reference file which includes COLUMN1 and COLUMN2. The use of COLUMN1 and COLUMN2 is not consistent so depending on what another program writes ORD12 may be in either COLUMN1 or COLUMN2.
My program needs to display all records where ORD12 appears in either COLUMN1 or COLUMN2.
The cross reference file is a PF with COLUMN1 as the Key and I created an LF with COLUMN2 as the key.
Is there a way to display the results of the search using the PF and the search using the LF?
For example:
The user enters a value, say ORD12.
I have a cross reference file which includes COLUMN1 and COLUMN2. The use of COLUMN1 and COLUMN2 is not consistent so depending on what another program writes ORD12 may be in either COLUMN1 or COLUMN2.
My program needs to display all records where ORD12 appears in either COLUMN1 or COLUMN2.
The cross reference file is a PF with COLUMN1 as the Key and I created an LF with COLUMN2 as the key.
Is there a way to display the results of the search using the PF and the search using the LF?
Comment