Re: keys on 2 joined files?

["Booth Martin" <Booth@xxxxxxxxxxxx>]

What happens if you create your join by the smallest unique unit?  ( policy
number)
 
 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: Monday, March 17, 2003 20:38:00
To: rpg400-l@xxxxxxxxxxxx
Subject: keys on 2 joined files?
 
Hello new guy here with a migraine starting problem

OK here is my problem.. i need to have a logical of 3 joined files ... the 
contract master, client relation master, and the client master. the problem 
is the contract and client master bother have something i need to sort with.

In contract i need the company code and employee location, then the client 
name from client master, then the policy number from contract. every thing i

try comes back in error and suggestions on how I can do this? I'm trying to 
have these come out by name but in order for the program to work they myst 
also be sorted by the employee location.

Thanks,
Chris
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

.