How can I convert an as400 physical file to an excel file using CLP or vice-versa? do you have a sample codes on this...? Thank you...
Announcement
Collapse
No announcement yet.
how to convert an as400 physical file to an excel file using CLP?
Collapse
X
-
Re: how to convert an as400 physical file to an excel file using CLP?
Originally posted by jrriveraHow can I convert an as400 physical file to an excel file using CLP or vice-versa? do you have a sample codes on this...? Thank you...
from .csv file to iseries table
Code:CPYFRMIMPF FROMSTMF('jamie/ALZIP.csv') TOFILE(JJFLIB/ZIPCODES) RCDDLM(*CRLF)
Code:/* Copy the temporary view to the incoming IFS file name. This com- */ /* mand assumes that the target IFS file is a CSV (comma separted */ /* variable" file and that it is to be converted to ASCII format. */ CPYTOIMPF FROMFILE(&FROMLIB/&FROMFILE) TOSTMF(&TOFILE) + MBROPT(*ADD) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF)
take care
JamieAll my answers were extracted from the "Big Dummy's Guide to the As400"
and I take no responsibility for any of them.
www.code400.com
Comment