Usage notes for the Open Query File (OPNQRYF) command

You need to be aware of these considerations when using the Open Query File (OPNQRYF) command.

Command elements
Here are the rules for field names and expressions specified on the Open Query File (OPNQRYF) command parameters, as well as a wide range of built-in functions that the OPNQRYF command supports.
Data type considerations
Here are the rules that govern the comparison and arithmetic of date, time, and timestamp values and the use of large object and DATALINK data types on the Open Query File (OPNQRYF) command.
DDM file considerations
The Open Query File (OPNQRYF) command can process distributed data management (DDM) files. However, there are some restrictions.
Input and output considerations
Here are the input and output considerations for using the OPTION parameter of the Open Query File (OPNQRYF) command and for field usage in an open query file.
Open data path considerations
An open data path (ODP) is a control block created when a file is opened. An ODP contains information about the merged file attributes and information returned by input or output operations.
Override considerations
Overrides can change the name of a file, library, and member that should be processed by an open query file. However, any parameters other than TOFILE, MBR, LVLCHK, INHWRT, or SEQONLY that are specified on an Override with Database File (OVRDBF) command are ignored by the Open Query File (OPNQRYF) command.
Program considerations
You need to consider these rules and techniques when running the Open Query File (OPNQRYF) command from a command line or when writing CL or other high-level language programs that use the OPNQRYF command.

Parent topic: Using Open Query File (OPNQRYF) command