RE: Import taking over 24 hours

A lot of their fields are variable length

On Mon, 9 May 2005 11:10:12 -0700, Joel Fritz wrote
> 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. 
*****************************
> 
> -- 
> 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)