Solved

AS/400 - Joining 5 PF in a Logical File

Posted on 2004-08-03
3
2,127 Views
Last Modified: 2010-10-05
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!!

Thanks.
0
Comment
Question by:viselli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Expert Comment

by:Mind_nl
ID: 11712787
How did you make the logical? An easy way to do this would be to make view. Open up iSeries Navigator and goto the database part in it. if you right click on a library you can create a new view. It is created like we are used to in MS access by selecting tables and dragging fields from one table to the other to specify the join. Here you would select a left-outer-join (select all rows in the left table and only those in the right table where the join is true)
0
 
LVL 1

Accepted Solution

by:
SuperCCA earned 50 total points
ID: 11713753
The DDS keyword you need is JDFTVAL.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RPG IV and RPG ILE book 4 493
FTP Error Control on the AS400 through Batch 4 777
Calling an iSeries system API (QWDRSBSD) from C# 4 533
ISeries Remote Location Route entry 2 28
By reading this blog, MSPs will gain insight into how to improve communications with their clients as well as establish a more profitable business.
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question