Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main use of OPNQRYF ?? in that query why we can
use OVERDBF and in that OVERDBY why should we use SHARE(*YES)
- 2 Answers
- 9320 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kapil kumar
It is not mandatory to use OVRDBF(*Yes) before OPNQRYF. You
can still use OPNQRYF without OVRDBF.
But here the pupose of the OPNQRYF won't be solved. Opnqryf
creates its own Open data path and to share the same data
path in a program we use ovrdbf share(*yes), if we do not
use ovrdbf, then program will have its own ODP, so it will
read the file from begining on which query has been run. So,
OPNQRYF selected records will have no importance. So, we
need to use CPYFRMQRYF command and put the selected records
in to runtime file and use that file to read in program
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
what is term cua , saa?
What is access path in as400?
what is rpg ?
how you will know whether you are in sfldrop or sflfold mode?
what is the syntax for plist?
what are dds required for subfile?
explain the use of dftwrt display keyword?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
What Is The Error If We Don't Get Login Screen?
what is the purpose of dynslt keyword?
how can a message from a message file appear as a constant on the screen?
what is the use of sflend keyword?
which cl command is used to trap error messages during program execution?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
how can you execute a command from within an rpg program without calling a clp program?
