CPYFRMIMPF csv to PF – Encounter Data mapping error

5 pts.
Tags:
.CSV files
IBM iSeries
RPGLE
How to resolve the issue of using command CPYFRMIMPF to copy those records with blank date field in the csv file to be imported into PF?

The date field in the csv file is '0000-00-00' and encounter error CPF5035 Data mapping error on member during the copy command and those records were ommitted.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb

    You could

    1. Preprocess the flat file to change the dates to 0001-01-01

    or

    2.  Create a file with a char field instead of date fields and use CPYFRMIMPF and then do a post process to fix the dates

    50,385 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following