iSeries: What’s the difference between MAP and DROP?

50 pts.
Tags:
IBM iSeries
iSeries Commands
What is the difference between *MAP and *DROP? What type of commands use these two keywords? Why we are use this? Please explain?

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is used in the Copy File CPYF command.
They are two of the values for the Record format field mapping (FMTOPT)
Map allows the CPYF to copy fields (columns) based on Field name.
Drop is necessary when Map is used if any fields (by name) in the from file don’t exist in the to file.
The default *NONE is used if the from and to files have identical structure
The value *NOCHK is used when you want a byte by byte copy without field constraints.

Phil

The *MAP option is usually used when:

  • You have redefined field(s) (for example, from packed 7,0 to packed 9,0)
  • You have rearranged the order of the existing fields
  • You have added new field(s) to the file

 

The *DROP option is usually used when you remove fields from the file

Kevin C. Ketzler

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    *MAP will match field name in from to field name in target.
    *DROP will ignore fields that do not exist in target file.
    111,200 pointsBadges:
    report
  • Kalinga9
    So what is the difference between *NONE & *DROP?. it looks like both are same!
    25 pointsBadges:
    report
  • TheRealRaven
    *NONE will fail if matching fields don't exist in the target file.
    27,660 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: