Upload and format CSV file to AS400.

pts.
Tags:
AS/400
RPG
I have a program that simply reads an uploaded CSV Excel file (CUPOBL), formats the fields and writes to a physical file on the AS400. The program currently writes the desired 20 records (disregards record 1), but does not populate with data. I can email a copy of the csv and a text file of the code. The HD fields are from the externally described CUPOBL1 file and the IN are internal to the flat CUPOBL file.

Answer Wiki

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

How are you uploading the CSV file? If you use a command like CPYFRMSTMF the data can be placed directly into an externally described file.

If your program is writing blank records if sounds like the data needs moved into the output fields. If you could post the code maybe someone could help with the exact cause.

Discuss This Question:  

 
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

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