Hi,This is raju.Can any body give me the real experience
answer for this question?
1.What is the significance of *MAP and *DROP in the CPY
command?
Answer Posted / nora alexander
It's for Record format field mapping - if you use *NOCHK it
just copies the data without regard to field type or size,
which is a bad idea.
*MAP
Fields with the same name in the from-file and to-file
record formats are copied, and any fields in the to-file
that do not exist in the from-file format are set to the
default value specified on the DFT keyword for the data
description specification (DDS) of the to-file or zero for
numeric fields, blanks for character fields, current
date/time for date/time fields, or null value for null-
capable fields.
If *MAP is specified, *DROP can also be specified. Mapped
fields may have different starting positions in the from-
file and to-file record formats.
If *MAP is specified and a valid conversion is defined
between the from-file field CCSID and the to-file field
CCSID, the character data is converted to the to-file field
CCSID. However, if either the from-file field CCSID or the
to-file field CCSID is 65535, the character data is not
converted.
*MAP allows for the conversion of date/time data and the
copying of null values.
*DROP
This value must be specified for field-level mapping if any
of the field names in the from-file record format do not
exist in the to-file format. If *DROP is specified, *MAP
can also be specified. When *DROP is specified, all the
field names that exist in both record formats must have the
same attributes and relative positions in the from-file and
to-file record formats, or *MAP must also be specified.
Null values are copied.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
how do I declare a table or array in rpg iv?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
what are the key words you must use when using a subfile?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
What is the difference between copybooks and subprocedures in as400?
How would display prime numbers using CL program?
what is file information data structure?
How Chain operation copies the record's data to the input buffer for the program?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
what is the necessary keyword needed to scroll subfile records?
how can you display specific subfile page on the screen in unequal subfile?
When it is desirable to describe files Internally?
What is a record lock error?