Create .csv file on IFS folder in AS/400

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

Answer Wiki

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

 
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.
  • Vladkats
    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
    Hi,

    I guess PTF listing can help in this respect.

    Thanks and regards
    Ashish@S
    1,330 pointsBadges:
    report
  • hunshabbir7
    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

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: