RE: Import taking over 24 hours

The database engine they are using is strictly a runtime, acucobol, and they 
will not provide us any additional info on the file layout.  We have 
confirmed that many of the fields are binary which means we cannot read them 
directly.

We are using Access just to dump the data out, their program is a cobol 
program written using acucobol, and no we don't have the source to that 
either....there is no way they will give us anything except the obj 
files.....we even tried talking to acucobol but they referred us back to the 
developers and said that since we are a customer of theirs they are under a 
contractual obligation ** NOT ** to assist us with any questions.  Which to 
me is baloney.....


On Tue, 10 May 2005 09:45:40 -0400, Haas, Matt wrote
> If Access is doing the conversion to the file you're importing, you
> should be able to look at the Access DB and figure out the file layout.
> 
> Also, are you sure that the "standard Unix COBOL files" aren't 
> already using a database (like DB2 or Oracle) that you can get to? I 
> would guess that since Access is coming into play, they're using an 
> ODBC driver to read the data from the Unix machine. Also, if they've 
> written their own routine in Access to write the file you import,
>  the VBA runtime in Access is incredibly slow doing direct disk I/O.
> 
> Matt
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme
> Sent: Monday, May 09, 2005 5:14 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Import taking over 24 hours
> 
> Part of the reason is that is the only way to really get the raw 
> data, since we don't have a layout of the file we are not positive 
> of where each field begins or ends.....the ftp routine is only 
> taking about 10% of the total
> 
> time to complete, the rest seems to be in parsing down the data.
> 
> On Mon, 9 May 2005 13:18:51 -0700, Alan Campin wrote
> > Why are you dumping the files to MS Access. You are running an 
> > RS/6000. Why not just FTP them directly to the AS/400 or to the IFS?
> > 
> > Also, you did not break down the various times. How much time for 
> > each phase of the project? Where are you spending your time?
> > 
> > -----Original Message-----
> > From: dpalme@xxxxxxxxxxx [mailto:dpalme@xxxxxxxxxxx]
> > Sent: Monday, May 09, 2005 6:44 AM
> > To: RPG Group
> > Subject: Import taking over 24 hours
> > 
> > We have been working on an import situation for a couple of months 
> > now, and I would like to get some feedback from some of you on this. 
> >  We have a RS/6000 which is running some older cobol programs, we 
> > are not in a position to replace those programs at this time, what 
> > we need to do is import that data (from standard unix cobol files 
> > ACUCOBOL to be exact) into several physcial files on our 9406-170.
> > 
> > We are using MS Access (which I hate but it serves its purpose here) 
> > to dump the data from the cobol files into tab delimited files which 
> > are then ftp'd over to the 400 and then imported into the physical
> files.
> > 
> > Everything does work but it is taking around 28 hours for the import 
> > process to complete.
> <snip>
> 
> -- 
> 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)