Using Open Query File (OPNQRYF)

Опубликовано: 23 Январь 2025
на канале: AS400 and SQL Tricks
272
4

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