Answer Posted / 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

what is the use of unique keyword and what level it is defined?

1602

---

what is cab?

1165

---

what is the maximum number of fields under a record format of physical file?

1850

---

what are the two record formats a subfile contain ?

1910

---

define the rcvf command?

1724

---

How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz

1699

---

what are the uses of factor1, factor2 and result field for the rpg operation code parm?

1040

---

what is the purpose of indicators in rpg?

1819

---

what is the purpose of dynslt keyword?

1753

---

what is externally described file ?

1655

---

What is data structure in as400? What is the use of data structure?

1085

---

How can we change the uppercase to Lowercase in RPG?

1428

---

what is the necessary keyword for non-join logical file?

1832

---

what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.

6914

---

what is the command to know key fields of file?

1176

---