RE: keys on 2 joined files?

You could use a multi-format logical file, or create a sequel to join the files 
and create a work file sorted the way you need it.

Tracy L. Ball
The Jackson Group
Sr. Programmer/Analyst 
(317) 781-4600 ext. 3107


-----Original Message-----
From: MEovino@xxxxxxxxxxxxxxxxx [mailto:MEovino@xxxxxxxxxxxxxxxxx]
Sent: Tuesday, March 18, 2003 12:11 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: keys on 2 joined files?



Chris,

I know this isn't really the answer to your question, but if nothing else,
you could always create a work file keyed the way you want and write to it.
My shop's standards prohibit join logicals (we fear what we don't
understand ;-) so we use this as a bail-out.

Mike E.




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.