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).

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: 1  Reply

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following