Re: Importing fencepost-delimited ASCII data

James,

As Charles wrote, if you are pretty sure of the "cleanness" of your
files, use CPYFRMIMPF. I wrote you about removing the header lines.
Wrong. I had forgotten about the FROMRCD parameter, where you can
specify the first record to be copied, as well as the number of them
to be included in your file.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries



On Fri, Jan 15, 2010 at 3:40 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

James,

You could use Scott Klement's routines for accessing IFS (root) files
within a RPG program (www.scottklement.com) . Also, I suppose you
could use the CPYFRMIMPF command (although you should be sure of
removing the header lines beforehand).


Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries



On Fri, Jan 15, 2010 at 3:19 PM, James H. H. Lampert
<jamesl@xxxxxxxxxxxxxxxxx> wrote:

It appears that I may soon find myself having to import a whole file of
fencepost-delimited ASCII data into DB2/400 files.

The file formats are known, in fact we have files that *should* be in
the target format.

The ASCII stream files appear to start with a line of field names.
Fields are delimited with ASCII fenceposts ('|', hex 7C), and records
are delimited by CRLF (hex 0D0A).

Two of the files are over a gigabyte; the third is over 300 megabytes.

Any suggestions on the most painless way to deal with this mess?

--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.