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 |
how to change the length of the field in a physicalfile?
Can an indexed file be accessed in arrival sequence in RPG?
I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
i would like to know under what circumstance the object will get locked on AS400.
can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E
Can we possible to key with the date field?
3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’
1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?
how do u find whether a record is locked or not??/
How to find d key field of a pf that doesn’t have source physical file?
How do I link an existing logical file to it's Physical File without recompiling?
wat is the difference between dataarea and data queue?
5 Answers Airtel, Four soft, Shahi Exports,