Home > IT Answers > AS/400 > Create .csv file on IFS folder in AS/400
Samule400
160 pts.
 Create .csv file on IFS folder in AS/400
AS/400 administration, AS/400 import/export, Comma Separated Values, CSV file format, 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).

Software/Hardware used:
ASKED: January 27, 2009  8:11 AM
UPDATED: September 25, 2009  3:02 PM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  September 25, 2009  3:02 pm  by  philpl1jb   44,070 pts.
All Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

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

Vladkats
 10 pts.