Q
Problem solve Get help with specific problems with your technologies, process and projects.

There's a problem with the CPYFRMIMPF command

I am having some problems with the CPYFRMIMPF command. The file that I am importing was scanned from user responses on a pre-printed form into a CSV file. The data on some of the records are of dubious validity so I need these problem records written to an error file. So far nothing that I have tried has written any thing to the error file. The file is created and is defined as having 1 field with nulls allowed. The job log tells me how many records were imported and gives me a message for every record not imported -- just nothing in the error file. My intent is to use what would be the record key of the records in the error file to create a list of keys for the data entry people to manually key these records. Any help that you might provide is greatly appreciated.

When dealing with data of dubious validity, I've had good luck with this approach. Create a file that the same amount of fields that are in your CSV file. Define all fields as alphanumeric, allowing nulls and big enough to hold your data elements.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.


Dig Deeper on iSeries ILE programming

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close