RE: Import taking over 24 hours

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>