Joining records

The Open Query File (OPNQRYF) command supports a dynamic join operation without data description specifications (DDS). You can join logical files as well as physical files, and you can specify keys from any of the join files. The command also allows missing records in secondary join files.