hello, i want to replicate some updates in a db2 table in mainframe to a
Oracle database in Unix box. I'm thinking in use triggers and ODBC to
connect to Oracle database. The cost of the solution is a serious
restriction (replication is discarded due license cost).
are ODBC drivers part of the DB2 standard distribution or extra feature ?

thanks in advance for the help

Haroldo
--

---

__o
_`\<,_
(_)/ (_)
~~~~~~~~~~~~


640K Will be enough.

Bill Gates.

I do not believe that ODBC drivers are part of DB2/mainframe. I think
you need to purchase DB2 Connect in order to get the DB2 client code
with the ODBC drivers in it. You wouldn't be able to use ODBC drivers
against the mainframe natively anyway, because of data conversion
issues. That is the idea behind DB2 Connect.

Larry Edelstein

HSP wrote:
> hello, i want to replicate some updates in a db2 table in mainframe to a
> Oracle database in Unix box. I'm thinking in use triggers and ODBC to
> connect to Oracle database. The cost of the solution is a serious
> restriction (replication is discarded due license cost).
> are ODBC drivers part of the DB2 standard distribution or extra feature ?
>
> thanks in advance for the help
>
> Haroldo
> --
>
> ---
>
> __o
> _`\<,_
> (_)/ (_)
> ~~~~~~~~~~~~
>
>
> 640K Will be enough.
>
> Bill Gates.
>
>

Thanks Larry!!

"Larry" <larry@nospam.net> escribió en el mensaje
news:yHvYd.22808$jp6.3109@fe11.lga...
>I do not believe that ODBC drivers are part of DB2/mainframe. I think you
>need to purchase DB2 Connect in order to get the DB2 client code with the
>ODBC drivers in it. You wouldn't be able to use ODBC drivers against the
>mainframe natively anyway, because of data conversion issues. That is the
>idea behind DB2 Connect.
>
> Larry Edelstein
>
> HSP wrote:
>> hello, i want to replicate some updates in a db2 table in mainframe to a
>> Oracle database in Unix box. I'm thinking in use triggers and ODBC to
>> connect to Oracle database. The cost of the solution is a serious
>> restriction (replication is discarded due license cost).
>> are ODBC drivers part of the DB2 standard distribution or extra feature ?
>>
>> thanks in advance for the help
>>
>> Haroldo
>> --
>>
>> ---
>>
>> __o
>> _`\<,_
>> (_)/ (_)
>> ~~~~~~~~~~~~
>>
>>
>> 640K Will be enough.
>>
>> Bill Gates.
>

Hi Haroldo,

Federation might be a little less expensive than Replication (if it is DPROP
for z/OS). You will need Websphere Information Integrator Advanced Edition
and Websphere Information Integrator Classic Federation. (Of course DB2/UDB
but can be out of the mainframe). The ODBC drivers I believe are included. I
know cost is an issue but it is really the matter of how much the issues you
try to solve costs to you or how much it is costing you and the implications
not solving those issues.

Thanks,

RdR

"HSP" <hsp@hotmail.com> wrote in message
news:d0t8cc$n8m$1@news1.nivel5.cl...
> hello, i want to replicate some updates in a db2 table in mainframe to a
> Oracle database in Unix box. I'm thinking in use triggers and ODBC to
> connect to Oracle database. The cost of the solution is a serious
> restriction (replication is discarded due license cost).
> are ODBC drivers part of the DB2 standard distribution or extra feature ?
>
> thanks in advance for the help
>
> Haroldo
> --
>
> ---
>
> __o
> _`\<,_
> (_)/ (_)
> ~~~~~~~~~~~~
>
>
> 640K Will be enough.
>
> Bill Gates.
>
>