Re: Import taking over 24 hours

["Douglas W. Palme" <dpalme@xxxxxxxxxxx>]

We tried that, but the data was all garbled, and it appears there are 
indexes included with the data, obviously we can run the RPG program once a 
week but we would prefer to have the data on a daily basis instead of weekly.


On Mon, 9 May 2005 13:57:14 -0400, Paul Morgan wrote
> Douglas,
> 
> Have you considered just looking at the file with a hex editor and 
> trying to figure out the format on your own?  Their documentation of 
> the data might be proprietary but it's your file and, unless there 
> is something in the contract, you should be free to reverse engineer 
> the file format.  If it's a stream file it can't be all that 
> complicated.  The file might have an index that would complicate the 
> format.  If it doesn't then it might be pretty simple to figure it 
> out.  Maybe the file has some header format data at the front of the 
> file (field and record sizes and such) which you have to skip over 
> to get to the record data you're interested in.
> 
> Paul
> 
> -- 
> Paul Morgan
> Senior Programmer Analyst - Retail
> J. Jill Group
> 100 Birch Pond Drive, PO Box 2009
> Tilton, NH 03276-2009
> Phone: (603) 266-2117
> Fax:   (603) 266-2333
> 
> Douglas wrote
> 
> > No, that's what I am trying to get or at the least, the file layout so we
> > can extract the data directly.....
> 
> -- 
> 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)