log inhelp

 | 

  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

CSV import files from iSeries database tables

Page history last edited by PBworks 16 years, 11 months ago

It is possible to create an import file, for example a comma delimited file for import to Excel, in the IFS from an iSeries physical file (database table) as follows:

First of all create the IFS file with the correct attributes by copying any source file as follows:

CPYTOSTMF FROMMBR('/qsys.lib/anylib.lib/anysrcpf.file/anymbr.mbr') TOSTMF('/lancasp/import.txt') STMFCODPAG(*PCASCII)

The use the CPYTOIMPF command to copy the physical file data into the stream file. For example

CPYTOIMPF FROMFILE(NCMAZDAW/NCDCRQP) TOSTMF('/lancasp/import.txt') MBROPT(*REPLACE) RCDDLM(*CR)

Comments (0)

You don't have permission to comment on this page.

Printable version