ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

how to convert an as400 physical file to an excel file using CLP?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to convert an as400 physical file to an excel file using CLP?

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

  • #2
    Re: how to convert an as400 physical file to an excel file using CLP?

    Originally posted by jrrivera
    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...
    use cpyfrmimpf or cpytoimpf


    from .csv file to iseries table
    Code:
    CPYFRMIMPF FROMSTMF('jamie/ALZIP.csv') TOFILE(JJFLIB/ZIPCODES) RCDDLM(*CRLF)
    fom iseries table to IFS (.csv) file
    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
    Jamie
    All 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

    Working...
    X