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 the valid data types in Data Queue?

1 Answers  

---

distinguish between terminating a program through seton lr and return?

0 Answers   IBM,

---

define the purpose of the leave operation?

1 Answers   IBM,

---

how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?

1 Answers   IBM,

---

define subsystem?

1 Answers   IBM,

---

---

what is lokup opcode?

1 Answers   IBM,

---

define a shared access path?

1 Answers   IBM,

---

What is the native language of AS/400?

1 Answers  

---

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

3 Answers  

---

How to create an Access path in Synon/2E ?

1 Answers  

---

when would you use or not use this approach?

1 Answers   IBM,

---

Difference between NOPASS & OMIT?

0 Answers  

---