AS/400 - Joining 5 PF in a Logical File
Posted on 2004-08-03
AS/400 Logicals Question:
I have five PF that I want to join and they all contain a key! When I join them I only get the records that match in all of the files instead of all records whether there is a match or not.
I.e. The first file has the employees personal information such as name, age. The second file has the employees first address, the third file has the employees second address etc...
When these files are joined, if the employee doesn't have a record in the second, third, fourth or fifth file, the results are not returned for that employee even though they exist in the first file.
Does anyone know how to get around this? I have no other choice but to create a logical!!