what is mean by *MAP and *DROP?what commands use these two
keywords?why are they used?
Answers were Sorted based on User's Feedback
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).
| Is This Answer Correct ? | 35 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 2 No |
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.
| Is This Answer Correct ? | 1 Yes | 10 No |
Answer / samba
we have 4 fields in one object and 4 objects in another object then we drop the fields
| Is This Answer Correct ? | 0 Yes | 9 No |
3 members in databasefile .how to read records from all the members??
What is the difference between ITER and DO ? I know both are used to execute set of statements repeatedly, but what is the main difference?
When a object will be locked & when a record will be locked? Plz explain.
suppose we have 10 members in physical file and i have to use 4 out of 10 so how can we read this in RPG
Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?
Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?
how can you display specific subfile page on the screen in unequal subfile?
If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?
In how many ways a session/device error occurs,,, and what is the remedy for it?
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
What is the difference between inner join @ outer join
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?