Using Open Query File (OPNQRYF)

Apply and get any of the following Credit cards:
Tata Neu HDFC Bank Credit Card bitli.in/ttF27x7
SBI cashback Credit Card bitli.in/dyRARm3
HSBC Live+ Credit Card bitli.in/qltAerg
IDFC First WOW Credit Card bitli.in/oscQvGh
HDFC Shoppers Stop Credit Card bitli.in/yRQ4mhj
SBI BPCL Credit Card bitli.in/4SynU9h
AU ALTURA Credit Card bitli.in/MnWekVq
AU ALTURA PLUS Credit Card bitli.in/92xHaNN
Axis Airtel Credit Card bitli.in/yLzz96F
IDFC First Credit Card bitli.in/p9t4rwy
IndusInd Legend Credit Card bitli.in/kKakvhm
IRCTC HDFC Bank Credit Card bitli.in/RPzj4Gi
Axis Flipkart Credit Card bitli.in/nlIPLG2
SBI Simply Click Credit Card bitli.in/IGjEZo9
HDFC Bank Credit Card bitli.in/jJ9daBB
Axis Indian Oil Rupay Credit Card bitli.in/1Z8o9oo
AU SWIPE-UP PLATFORM Credit Card bitli.in/wsjGvu5
Swiggy HDFC Bank Credit Card bitli.in/zSMXmZ6
Axis Magnus Credit Card bitli.in/uBCxYy7
AU LIT Credit Card bitli.in/yd83btW
IndusInd Platinum Credit Card bitli.in/nz057ls
IndusInds Rupay Platinum Credit Card bitli.in/fGxjymZ
Axis My Zone Credit Card bitli.in/LtGmH8l
Axis Indian Oil Credit Card bitli.in/mLdpL3D
ICICI Bank Credit Card bitli.in/6ZwTutS Get 20% OFF on purchasing Web Hosting with Hostinger through this link hostinger.in?REFERRALCODE=1FARHA69 #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.