Re: Problem in creating Join Logical File

[MWalter@xxxxxxxxxxxxxxx]

An SQL View


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "hrishikesh
                    kotwal"                  To:     rpg400-l@midrange.com
                    <hdkotwal@hotmail        cc:
                    .com>                    Subject:     Problem in creating 
Join Logical File
                    Sent by:
                    rpg400-l-admin@mi
                    drange.com


                    01/03/02 03:45 AM
                    Please respond to
                    rpg400-l






[ Converted text/html to text/plain ]

Dear all,



A Happy New Year to all !

Following are rules related to define Key fields in a Join Logical Files:

The key fields must exist in the primary physical file.

The key fields must be named in the join record format in the logical file
in
positions 19 through 28.

The key fields cannot be fields defined as neither fields (N specified in
position 38 for the field) in the logical file.

I have to create a Join file which must have Key fields from both files,
what
is the best solution to achieve this?


Regards,

Hrishikesh Kotwal


------------------------------------------------------------------------------

MSN Photos is the easiest way to share and print your photos: Click Here[1]

===References:===
  1. http://go.msn.com/bql/hmtag3_etl_EN.asp

_______________________________________________
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.