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?
Answers were Sorted based on User's Feedback
Answer / rakesh
Hey Raju,
Actual Significance is *MAP will Map the Field
from From File to To File where ever it will find mapping
without error where as *drop will Drop off the Field where
ever it is not matching .
For Example : we want to copy 12 fields file data to
another File having 12 Fields plus 3 more addon , we have
to use the *Map and *Drop to add the data of 12 match
fields and drop the remaining.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / venki
i think it does not need that mush of cinfusion *map is for
just it checks he record format of to files *drop is also
same but it ignores the fild attribute it cheks for wheher
the teo data types are comptable or not
Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of record level identifier?
what are the array operations?
How can a screen field that has changed since the last output operation be detected?
Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?
list down and describe the sub systems vailable
How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20
1. Which Built-In-Function will you use to achieve the following functionality? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2++÷ResultLenDHHiLoEq C QTY IFLT *ZERO C QTY MULT -1 QTY C ENDIF a) %ABS b) %TRIM c) %TRIMS d) %UNS
what are the key words you must use when using a subfile?
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
Why we cannot call a service program? If I add a PEP can i call the service program?
i want code and what are used key words are ...like wrkmbrpdm screen (q) i have a file with 3 fields empno,empname,empaddr... here you give the empno it displays from that number to remaining empno's how? sub file screen: employee details pos to:empno then enter empno empname empaddr so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining... ...... please share this answel