WHAT IS JOIN LOGICAL FILE

•    Join logical files concatenate the fields from the records in two or more physical file and process them as one record.

•     You can specify only one record format in a join logical file.

•     The creation of a join logical file depends on theSE seven keywords JFILE, JOIN, JFLD, JREE, JDUPDEQ, JDFTVAL, and DYNSLT.

1.  http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fdbp%2Frbafojnlof.htm
2. http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fdbp%2Frbafoacjlf.htm 
3. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fdbp%2Frbafox2phyf.htm