Re: OPENQRYF question

["Charles Massoglia" <cmassoglia@xxxxxxxxxxx>]

If you are joining File 1 to File 2, key the the join file by the
employee SSN of File 1.  Use JDUPSEQ for Last Name on File 2.  You can
not specify a key from the secondary join file.

But if File 2 contains both the SSN and the Last Name, why not join
File 2 to File 1 and key the join file by Last Name and SSN from File
2?

> Does anybody know a good CLLE reference on OPENQRYF?  I have been
looking
> for an example on how to build one that does the following:
>
> File 1 is keyed by employee SSN.
> File 2 has employee SSN and Last Name, keyed by last name.
>
> Is it possible to do a joined OPENQRYF in order to build a key on
File 1 by
> last name?  Or can anybody think of a better way to do this?
>
> Thanks much,
>
> Benjamin Deaver
> Programmer
> Labatt Food Service
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

Charlie Massoglia