Re: Importing fencepost-delimited ASCII data

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.