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 ? | 34 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 |
what do you mean by an input subfile, what are the keywords required?
I have 1000 records in a file. I would like to generate 10 identical reports from this record with same format (structure of records) how do I do this?
what is importance of 'MAPFLD' IN OPNQRYF FILE ?
Difference between RESET and CLEAR
Can you copy the records created by the OPNQRYF to other files and how?
1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?
Need a sql query: retrieve all duplicate records in table?
can i use UPDDTA command in rpg program in which contains a file
How to identify the object has compiled with the debug view as *source without using STRDBG?
When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?
1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?
I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.