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

how many files can be defined in f specs?

2253

---

how can I automatically refresh a web page?

1016

---

what are dds required for subfile?

988

---

what is a keyed physical file?

1738

---

1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?

963

---

how can a cgi check whether an ifs object is available?

1042

---

hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.

2510

---

what is sflpag and sflsiz ?

3282

---

what are different types of substems?

2130

---

is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

1001

---

what are indicators?

988

---

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

1903

---

what are the three line types in rlu ?

2097

---

what is the use of jdftval in join logical file?

1728

---

in conjunction with what other keyword must ovrdta and ovrata be used?

1479

---