creating a .csv from iseries file

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: Last updated:
Related Questions
1

Answer Wiki

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

 
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.
  • BrentSheets
    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,950 pointsBadges:
    report

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.

Following

Share this item with your network: