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.
November 21, 2008 12:22 AM
December 1, 2008 4:20 PM