Create .csv file on IFS folder in AS/400

Samule400

160 pts.

Tags:

AS/400 administration

AS/400 import/export

CSV

IFS

V4R3

Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

Asked: January 27, 2009 8:11 AM Last updated: October 3, 2014 12:13 PM

Answer Wiki

Last updated: September 25, 2009 3:02 PM GMT

philpl1jb54,090 pts.
History
Contributors
- Ordered by most recent
- philpl1jb54,090 pts.

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

Hi Samule400
You can copy a db2/400 file using CPYTOIMPF to the ifs
The defaults are for a CVS file .
Leave the to data base file blank
Use the to stream file to identify the path and ifs file name — included the .cvs
Phil

***************
Vlad

Please post this as a new question, so that others can respond.
I know their are people with more CCSID experience than I have.
Incldue the CCSID of the file you’re coping and if the stream file already exists.

Phil

Discuss This Question: 3 Replies

Vladkats Sep 25, 2009 2:49 PM GMT

Hello Phil , I am trying to copy a db2/400 file to the IFS using CPYTOIMPF but getting the unreadalbe data. For example two char. fields containing 'A' and '1' got converted to 'Áñ%'. I use the following for command: FROMCCSID = *FILE STMFCODPAG = *STMF RCDDLM = *CRLF DTAFMT = *FIXED NULLIND = *NO If I use STMFCODPAG =*PCASCII or *STDASCII it gives me "The CCSID or code page value is not valid. " error. Thank you, Vlad

10 pointsBadges:

report
AshishSingh10 Oct 3, 2014 4:12 AM GMT

Hi,

I guess PTF listing can help in this respect.

Thanks and regards
Ashish@S

1,330 pointsBadges:

report
hunshabbir7 Oct 3, 2014 12:13 AM GMT

CPYTOIMPF is the command used to copy physical file data to a "CSV" file. In question it is not asked that he want to copy physical file data to csv. He just want to create csv file.

2,900 pointsBadges:

report