Using Open Query File (OPNQRYF)

Veröffentlicht am: 06 Juni 2024
auf dem Kanal: AS400 and SQL Tricks
589
6

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=1FA... #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.


Auf dieser Seite können Sie das Online-Video Using Open Query File (OPNQRYF) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer AS400 and SQL Tricks 06 Juni 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 589 Mal angesehen und es wurde von 6 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!