creating a .csv from iseries file

Shelties

10 pts.

Tags:

CPYTOIMPF

IBM 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

Asked: December 18, 2007 3:28 PM Last updated: January 10, 2008 4:58 PM

Answer Wiki

Last updated: January 10, 2008 4:58 PM GMT

VBOTone55 pts.
History
Contributors
- Ordered by most recent
- VBOTone55 pts.

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

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)

Discuss This Question: 1 Reply

BrentSheets Dec 18, 2007 6:20 PM GMT

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.

6,940 pointsBadges:

report