How do I convert a Unix text file from IFS to a DB file on AS400?

2740 pts.
AS/400 FTP
Copy From Import File
Database administration
Flat files
I've got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. Both files can be displayed on IFS no problem. The problem I run into while running the CPYFRMIMPF command is that the data will copy over to a flat file successfully but when I display the file or query the file the data is unreadable. CPYFRMIMPF FROMSTMF('/dir/Test/test.txt') TOFILE(testlib/test) MBROPT(*REPLACE) STMFLEN(*TOFILE) RCDDLM(*LF) DTAFMT(*DLM) STRDLM(*NONE) RMVBLANK(*NONE) How do I convert this file at all to a library/File.member? Second how will I convert this file to fill in a formatted file? The flat file is fixed length and I should be able to break it down by character lengths. I know if I could get Unix to output a CSV file then my life would be alot easier, but I need to be confident that this will work at all before I demand a new file design.

Answer Wiki

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

You’ll find a discussion of this on
Page 141
Basically you describe the incoming data as fixed format and create a field definition file to map it to fields in you physical file. (page 142)

Is this a fixed lenth flat file that you are sending to the IFS? If so, you may want to use CPYFRMSTMF.

Discuss This Question: 4  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.
  • Gilly400
    Hi, Why don't you FTP directly to the AS400 (creating or appending to a flat file)? Regards, Martin Gilbert.
    23,730 pointsBadges:
  • slack400
    I've tried FTP directly to a flat file but the data doesn't translate. I've tried ASCII and BIN. I know that this method will make things easier down the road. Eventually this company will be looking to Oracle for an ERP solution and it probably won't be running on an AS400. So any data transmissions going to the AS400 will be designed with the IFS in mind.
    2,740 pointsBadges:
  • philpl1jb
    Is it all garbage or just the numeric fields? Phil
    54,090 pointsBadges:
  • Gilly400
    Hi, If you're getting garbage through, the chances are that you have a different CCSID (coded character set Id) on the source system to the target system. You can convert from one CCSID to another on the CPYFRMIMPF command (press F9 to get to the extra parameters). Regards, Martin Gilbert.
    23,730 pointsBadges:

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.


Share this item with your network: