NONJOIN LOGICAL FILES

Simple and multiple format logical files in DDS

You must specify the PFILE keyword at the record level for simple and multiple format logical files. In a multiple format logical file, a record format can use only the fields common to all the physical files specified on the PFILE keyword for that record format.

Specify the entries in the following order to define a simple or multiple format logical file:

1. Optional: File-level entries
2. Record-level entries
3. Optional: Field-level entries
4. Optional: Key field-level entries
5. Optional: Select and omit-field level entries

reference
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/topic/com.ibm.etools.iseries.langref2.doc/rzakb/simpmult.htm

• Creating a logical file
• Describing logical file record formats
• Describing access paths for logical files
• Setting up a join logical file

• Creating a logical file with more than one record format
• Identifying which record format to add in a file with multiple formats