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 to define global parameter in ile ?

1264

---

What are the mandatory keywords of sub file?

1539

---

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2405

---

what are the three types of keywords associated with printer file ?

1761

---

what is a primary file?

1830

---

what is the difference between packed decimal and zoned decimal?

3347

---

how can you specify no duplicate key?

1212

---

what is the purpose of indicators in rpg?

1885

---

list some of the commonly used commands for debugging?

1719

---

what does opcode post do ?

1844

---

how to define to define a hidden filed in dspf ?

1403

---

What is diff between EVAL & MOVE?

1621

---

What is dynslt?

1281

---

Space & Skip Are Which Level Keywords?

1239

---

what is a join logical file?

1260

---