Re: Accessing AS400 from Oracle 9i

From: Cris Otto Partz <cris119_at_operamail.com>
Date: Fri, 13 Jun 2003 11:09:22 +0200
Message-ID: <bcc4bu$euv$1@panco.nettuno.it>

Ralf Jonas wrote:

> my current job is to periodically transfer a table from an AS/400 into an
> oracle table. The AS/400 can be easyly connected via JDBC using the
> jt400.jar so I wrote a stored java procedure to do this task. Furthermore I
> can call this job periodically from DBMS_JOB.

Is there a reason to put this task into the DB? What about writing an external java app that access both Oracle and AS/4000 via JDBC? You can schedule this task using the operating system facilties (e.g. at, cron).

Kind regards,

-- 
Cris Otto Partz (spamto:cris119_at_operamail.com)

We are SCO.  Unix is our property.
Linux is illegal.  Prepare to be sued.

Received on Fri Jun 13 2003 - 04:09:22 CDT