creating a .csv from iseries file
Home > IT Answers > AS/400 > creating a .csv from iseries file
Shelties
10 pts.
0
Q:
creating a .csv from iseries file
iSeries, CPYTOIMPF
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: Dec 18 2007  3:28 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
VBOTone
55 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jan 10 2008  4:58 PM GMT by VBOTone   55 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

BrentSheets   6535 pts.  |   Dec 18 2007  6:20PM 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.

 
0