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

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.

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

Answer / rake

we can insert a field using MAPFLD in opnqryf

what are all the contents of subfile?

1 Answers   IBM,

---

In Which Specs Arrays, Tables & Constants Are Defined?

0 Answers   IBM,

---

what opcode will be used to test the zone of a character field?

1 Answers   IBM,

---

what is the use of CPYFRMQRYF?

4 Answers  

---

What is the symbol used for defining a new field in SDA?

1 Answers  

---

is there any way I can ease my rpg controls on numeric input fields? How about an input date field?

0 Answers   IBM,

---

explain the purpose of keep and assume keywords?

1 Answers   IBM,

---

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

0 Answers  

---

Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers  

---

How to increase 3 days from my current date in RPG Program?

3 Answers   Mind Tree,

---

how to get no of records in file in rpg with out cl cmd

2 Answers   iGate,

---

we have 2 PF files with same name, how to copy data's from one file to another through RPG program logic?

3 Answers  

---