I copied a PF to text delimited file in IFS using the Command below. The data looked good when view in IFS Folder all the fields line up properly but when viewed in Windows Explorer, the format is not lining up correctly. The next record continues to the last position of the first record. One of the field in the file contains Carriage Return and underlines, because this is imported from a web application and copied to AS400 PF. When I used RCDDLM(*CRLF) the fields that contains CR is adding new line on the text file. We are on V5R4M0. Any help will be greatly appreciated.
CPYTOIMPF FROMFILE(PSFCLRIFY) TOSTMF('/FTPFILE/TestFile.txt') MBROPT(*REPLACE) STMFCODPAG(*PCASCII) RCDDLM(*LFCR) DTAFMT(*DLM) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM('|')
Thank you... REC
CPYTOIMPF FROMFILE(PSFCLRIFY) TOSTMF('/FTPFILE/TestFile.txt') MBROPT(*REPLACE) STMFCODPAG(*PCASCII) RCDDLM(*LFCR) DTAFMT(*DLM) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM('|')
Thank you... REC
Comment