RE: Import taking over 24 hours

["Joel Fritz" <JFritz@xxxxxxxxxxxxxxxx>]

If you can get the files into an AS/400 flat file, you can load them
into a user space and parse the data with an RPG program one character
at a time. Load the data from the user space into a fixed size buffer to
avoid doing too much I/O. I've never done that with anything very large,
but I know it works.  We get files from a credit card processor that
insists on sending them in binary form.  We do have a file layout
though; it comes in handy since there are some variable length fields.

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme
> Sent: Monday, May 09, 2005 9:06 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Import taking over 24 hours
>
> Part of the problem is the files are a cobol stream file and
> we do not have the file layout, the vendor that wrote that
> program is unwilling to provide us with that information....I
> am trying to negotiate a deal with them for the info, but so
> far they have claimed its proprietary.
>
>
> On Mon, 9 May 2005 11:15:16 -0400, Jon Paris wrote
> > Why not access the RS/6000's file system through the IFS route and
> > process the flat files directly with an RPG program?  Why
> waste time
> > going through tab delimited etc?
> >
> > Jon Paris
> > Partner400
> >
> > www.Partner400.com
> > www.RPGWorld.com
> >
> > --
> > This is the RPG programming on the AS400 / iSeries
> (RPG400-L)  mailing
> > list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe, or change list options, visit:
> > http://lists.midrange.com/mailman/listinfo/rpg400-l or
> email: RPG400-
> > L-request@xxxxxxxxxxxx Before posting, please take a moment
> to review
> > the archives at http://archive.midrange.com/rpg400-l.
>
>
> --
> Open WebMail Project (http://openwebmail.org)
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

*****************************
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise 
recorded by
The Sharper Image corporate e-mail system and is subject to archival, 
monitoring,
and review by and/or disclosure to Sharper Image security and other management.
This message is intended only for the use of the addressee and may contain 
information
that is privileged and confidential.

The contents of this message may contain personal views which are not the views 
of The Sharper Image.
If you are not the intended recipient, dissemination of this communication is 
prohibited.
*****************************