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 can a message from a message file appear as a constant on the screen?

1560

---

what is the purpose of putovr (put with explicit override) keyword?

1631

---

What is dynslt?

1199

---

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2509

---

what is a query can be run in which mode?

1290

---

What is %CHECK?

1255

---

what is a non-join logical file?

1795

---

A join logical file has how many record formats?

1106

---

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...

2342

---

what is the maximum number of record formats in dspf?

1669

---

what are the different types of data areas?

1720

---

Write a logic program for knowing the repeated number of a vowels in a given program?

3725

---

is there any way to dynamically merge other html scripts into a given html?

1059

---

define subsystem?

1603

---

what is the difference between *like and *namvar ?

2515

---