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 |
what are the key words you must use when using a subfile?
suppose one file is used by 100 user and file is locked by 100 user, what are the impact analysis?
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.
What are the commands that can be executed in CLP but not in RPG? Why?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
To check the locks , we use cmd WRKOBJLCK , but how we confirm whether it's objeck lock / member lock. I confused with the Lock type and Status values...Can any body please tell me ...
what is commitment control?explain about it?
how do I declare a table or array in rpg iv?
How to print output from openquery in as400 ?
How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...