RE: Filetransfer to Oracle

["Gamache, Fred (HT-EX)" <FGamache@xxxxxxxxxx>]

We are doing this two ways.  We use the Oracle Gateway to the AS/400
which basically lets you see AS/400 files from within Oracle.  To an
Oracle application, the files appear as Oracle tables.  This is
obviously very flexible, but it is also very slow.  It does OK for
interactive applications, but for batch transfers does not work well.
To do batch transfers we have written RPG programs on the AS/400 to
create flat files which we then FTP to the Oracle server.  We then use
SQL Loader to load that data into the Oracle database.  This is more up
front work, but is much faster execution for regular file transfers.

Fred Gamache
fgamache@gic.gi.com

>----------
>From:  Maurice Langeveld[SMTP:MauriceLa@EnerTel.nl]
>Sent:  Tuesday, April 29, 1997 10:49 AM
>To:    'AS/400 mailinglijst'
>Subject:       Filetransfer to Oracle
>
>We want to transfer some data to Oracle, we are searching for a quick
>and automatic way to do it. I do not know if someone is doing this, I
>think so, all information welcome.
>
>Maurice.
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* This is the Midrange System Mailing List!  To submit a new message,   *
>* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
>* this list send email to MAJORDOMO@midrange.com and specify            *
>* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
>* should be directed to the list owner / operator: david@midrange.com   *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *