CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
- 4 Answers
- 11684 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manish kumar
MAPFLD is used to change the format of the fields used in
the OPNQRYF statement. When I say changing the format the
format of the field will not be changed but we can format
the data as we wish and store it in a diffrent variable.
For eg. You want check for year to be some value and are not
concerned abt date and month then you can follow as below.
OVRDBF FILE(FILEA) SHARE(*YES)
OPNQRYF FILE(FILEA) QRYSLT('YEAR *EQ "88" ') +
MAPFLD(YEAR '%SST(DATE 5 2)' *CHAR 2)
CALL PGM(PGMC)
CLOF OPNID(FILEA)
DLTOVR FILE(FILEA
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sumit gupta
Hi Suma..your question is wrong...OPNQRYF is used to select
some records from a physical file which is overide or
simple 1 file(without OVRDBF).
We cannot insert field into physical file throgh OPNQRYF.
But yes you can change the format of field as SAID BY
MANISH and then bys using CPYFRMQRYF...you can write the
selected record into physical file.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / venkat
it is not possible to insert a field using openquery file
because of there is no parameter to insert the field at
opnqryf
| Is This Answer Correct ? | 3 Yes | 0 No |
what is the function of cpysplf command?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
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)
How to inner join more than 2 PFs in a CL program using OPNQRYF command?
What the difference between Source Physical File and Physical File?
define data structure?
what is the purpose of DMPCLPGM IN CL?
define the purpose of the %sst function?
what does check opcode is used?
what is the command to rtrieve system date? options:1.rtvsysval 2.rtvjoba 3.rtvjobd 4.both a and b
what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?
How to read data from *LDA (Local Data Area) in RPGLE program without using IN opcode?
RPG400 
