Re: Data Transfer from DB2400 to Oracle

[Ravi Viswanathan <ravi@xxxxxxxxxxxxx>]

> Kiran,

You might want to check out Oracle Access Manager. This allows AS/400 embedded 
SQL
programs to seamlessly access  (read, write, update) data in an Oracle DB. The
product can also be used through AS/400 ISQL. Works great!!

Ravi

>
> ks_kiran@tkm.satyam.net.in wrote:
> >
> > Hi guys,
> >
> >          My Name is K.S. KIRAN working as systems engineer at Toyota
> > Kirloskar Motor Ltd., India.
> > We at Toyota have multiple servers  Windows Nt, AS/400, RS/6000. I want to
> > transfer some data
> > from AS/400 to ORACLE and vice versa. Can anyone help me. I know one method
> > which i can do is
> > Use CPYTOPCD command and take the ascii text file in a floppy and use
> > SQLLOAD at Oracle end.
> > I want some other method(Online). This method is ridiculous. Can anyone
> > help me.
> >
> > With Regards
> > K.S. Kiran
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator: 
>david@midrange.com
> > +---
>
> --
> IBM AS/400 communications, FTP automation, and network security
> software and consulting services.
>
> http://www.patownsend.com
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | 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 subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---