Home > IT Answers > AS/400 > creating a .csv from iseries file
Shelties
10 pts.
 creating a .csv from iseries file
CPYTOIMPF, iSeries
I've asked this question before and was told to change the parm in CPYTOIMPF to STMFCODPAG(819). The date in the .csv file is garble. CPYTOIMPF FROMFILE(qtemp/&FILE_NAME) + TOSTMF('/ILS/payops/*tcat &file_name *tcat '.csv') (*REPLACE) + STMFCODPAG(819) RCDDLM(*CRLF) + DTAFMT(*DLM) STRDLM(*NONE) What else can I try. Thanks. Lou

Software/Hardware used:
ASKED: December 18, 2007  3:28 PM
UPDATED: January 10, 2008  4:58 PM
RELATED QUESTIONS
Answer Wiki:
I recently created a .csv with dates. Here is an example of the command. CPYTOIMPF FROMFILE(MYLIB/DATEFILE) TOSTMF('//Apps/DateFile.csv') MBROPT(*REPLACE) STMFCODPAG(*PCASCII) RCDDLM(*CRLF) In NoteBook, the dates looked just fine (*ISO). When I opened it in Excel, they were converted to *USA format. Also, if the file already exists, just use the code page of the existing file. The copy command will convert it for you. CPYTOIMPF FROMFILE(MYLIB/MYFILE) TOSTMF('//Apps/MyFile.csv') MBROPT(*REPLACE) STMFCODPAG(*STMF) RCDDLM(*CRLF)
Last Wiki Answer Submitted:  January 10, 2008  4:58 pm  by  VBOTone   55 pts.
All Answer Wiki Contributors:  VBOTone   55 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Shelties, you asked a similar question just 4 days ago and another member responded. Now you start a separate question as a follow up. This makes it harder for people to answer you. In the future, please simply update your original question by adding to the discussion of your original question — so that all dialog continues more seamlessly under one question. Thanks for you cooperation.

BrentSheets
 6,580 pts.