Re: Import taking over 24 hours

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)