Answer / naru

Why *MAP and * DROP?
When we copy data from FILE A to FILE B and if FILE A has
20 fields and FILE B has 30 fields (say there are 10 fields
which is not common among both the files). Using *MAP and
*DROP option we can copy the data from FILE A to FILE B.
All the fields would be mapped between both the files and
the unmatched fields would be dropped.

Which command uses *MAP & *DROP - CPYF command (Copy file).

Answer / panduranga nayak

The keywords *MAP and *Drop is used by the IBM command CPYF.
This keywords are used to MAP the column or drop the column
whenever a field added/Deleted from a physical file.

Answer / manoj

Both keyword are used in cpyf command
*MAP will check byte by byte.
When we copy the records from one file to other file then
we used CPYF command.

Answer / samba

we have 4 fields in one object and 4 objects in another object then we drop the fields

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

0 Answers  

---

Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.

1 Answers  

---

What is the difference between RPG/400 and RPG4

1 Answers   HCL,

---

How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

0 Answers  

---

Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?

1 Answers  

---

How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?

4 Answers   CTS,

---

I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)

3 Answers   Opus,

---

As Packed veriable store 2 digits in 1 byte and ZONE variable store 1 digit in 1 byte... Please tell me when we have to use Packed and Zone variable...?

1 Answers  

---

how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

2 Answers   iGate,

---

can anybody help me that what is the procedure of debugging the service program?

3 Answers   CSC,

---

Can any one plz explain the concept of INFSR, *PSSR, INFDS AND PSDS, I' confusing about PSDS and *PSSR, Wat is the difference btw them, wat PSDS will do????

1 Answers  

---

Anybody can explain the difference between SFLCLR & SFLINZ?

7 Answers  

---