Exporting Records from AS400 file to an ASCII delimited file

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Pietro E Reyes, III

    Exporting Records from AS400 file to an ASCII delimited file

    As can be noted from the subject, am not a techie.

    I need to export database records in a core application software on our
    AS400iseries into an ASCII comma delimited file on a PC so I can import it
    into a PC database program.

    What is the least cost (preferrably no-cost) way of doing this?

    TIA to all who reply.


  • Kent Milligan

    #2
    Re: Exporting Records from AS400 file to an ASCII delimited file

    CPYTOIMPF CL command

    --
    Kent Milligan, DB2 & BI team
    PartnerWorld for Developers, iSeries
    kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!![color=blue][color=green][color=darkred]
    >>> www.iseries.ibm.com/db2[/color][/color][/color]
    (opinions stated are not necessarily those of my employer)

    Comment

    • Kent Milligan

      #3
      Re: Exporting Records from AS400 file to an ASCII delimited file

      CPYTOIMPF CL command

      --
      Kent Milligan, DB2 & BI team
      PartnerWorld for Developers, iSeries
      kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!![color=blue][color=green][color=darkred]
      >>> www.iseries.ibm.com/db2[/color][/color][/color]
      (opinions stated are not necessarily those of my employer)

      Comment

      Working...