RE: Join Files

See JDFTVAL in the DDS reference....

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Wereschuk
Sent: Thursday, September 21, 2006 10:33 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Join Files

Hi All:   I have set up a join file on 2 physical files and am
successfully getting the information I need with the following
exception.

 

            When I have a record in the primary file that does not have
a record in the secondary, I still want to retrieve the primary record.
Is this possible using a Join Logical and if so how and if not is there
a better way to accomplish this?

 

            I have tried searching the archives but the only thing I
found was discussions on using keys from primary and secondary and not
anything about the problem I am having? 

            Any help or direction would be greatly appreciated.

 

 

******************************************

Don Wereschuk

ISD  - Programmer/Analyst

Simcoe Parts Service Inc.

Phone:   705-435-7814          Ex: 302

Fax:         705-435-6746

dwereschuk@xxxxxxxxxxxxxxx

******************************************