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

How to Define a Procedure in RPG?

0 Answers  

---

i want to display the 10000 record in a subfile by using loadall , can we do it?

10 Answers   CybAge,

---

If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

0 Answers  

---

when this error ocuurs in openqry file 'OPNID(BANKPF) for file BANKPF already exists.'?

2 Answers   ITC Infotech,

---

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

2 Answers  

---

what is the correct about QTEMP library(below mention)? a.it is Unique to a job b.it can be shared between different job c.it can only be deleted by QSECOFR d.Non Please give me the answer for this?

8 Answers   Wipro,

---

is it there an easy way to determine if an html section is available to issue a wrtsection upon?

0 Answers   IBM,

---

in which specification the report layout can be defined?

1 Answers   IBM,

---

Hi i have one question In my srvpgm one module ADDM is there now i want to add new module i.e SUBM , please answer me IN STEPS how to write bndlanguage and how it was attach to SRVPGM

2 Answers   IBM, Satyam,

---

Difference Between Skip Before & Space Before?

0 Answers   IBM,

---

maximum number of subfiles that can defined in a rpg program for one display file is?

1 Answers   IBM,

---

Can you use multi format LF in CL program?

2 Answers  

---