Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the ..

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

Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the ..

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

Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the ..

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

Post New Answer

More RPG400 Interview Questions

How do you find whether a job is a batch job or interactive?

4 Answers  


How to print output from openquery in as400 ?

1 Answers   Four soft,


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...

2 Answers  


i would like to know under what circumstance the object will get locked on AS400.

5 Answers   IBM,


Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers   TCS,


What is the purpose of Panel Groups?

4 Answers  


what is the rpg system?

0 Answers   IBM,


we hav job which is running as batch. it takes atleast 06hours to complete tht job. bu i wana do tht job with in 3hours.........? so plz post ur answers

8 Answers   Cap Gemini, IBM,


two types of read performed in dataqueue?????

4 Answers   CTS,


1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?

3 Answers   HSBC,


If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?

1 Answers  


give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

0 Answers   CTS,


Categories