Re: Can we have a Key fld from 2nd file in Join Logical

[vhamberg@xxxxxxxxx]

No, I guess. From the DDS manual, v5r1

For join logical files, the key field name you specify
must be specified at the field level in positions 19
through 28 and must be a field described in the primary
file (the first physical file specified on the JFILE
keyword).

But you can with SQL SELECT statements.
> When we are joining two files, is it possible to have a Key field from the
> second file in Join Logical file?
> Any help is greatly appreciated.
>
> thanks.
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>