Using Open Query File (OPNQRYF)

#ibmi #as400 #clle
OPNQRYF
Using Open Query File (OPNQRYF)
1-Create temporary access path for file
2-discard it after its use
3-dynamic access path at run time
4-Used - select set of records as per query
- order records
- group records
- join records
Open Data Path:(ODP)
1-temp object used to create dynamic access path
2-ODP holds
- file name
- format name
- current record pointer
- record selection etc
3- ODP has only one cursor.
Each PGM that shares same ODP have one image of cursor.
4- To share access path,
- create an ODP in CL program with OPNQRYF command.
- share ODP in RPG using SHARE(*YES) in OVRDBF command.