Create .csv file on IFS folder in AS/400
Home > IT Answers > AS/400 > Create .csv file on IFS folder in AS/400
Samule400
60 pts.
0
Q:
Create .csv file on IFS folder in AS/400
AS/400 import/export, IFS, AS/400 administration, V4R3, Comma Separated Values, CSV file format
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: Jan 27 2009  8:11 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24570 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Sep 25 2009  3:02 PM GMT by Philpl1jb   24570 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

Vladkats   10 pts.  |   Sep 25 2009  2:49PM 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

 
0