Re: DB2 via Oracle Transparent Gateway

The Powers at PowerSoft have shed some light on my problem(s)...

You cannot update DB2 tables via the Database Painter through a view on the oracle gateway. It just cannot be done :(

When building a datawindow that is based on a view, there are a few things that need to happen.
First, the tab orders for the data window are all '0'. This makes it hard to enter any data into the data window. Second, you need to edit the 'Update' properties for the data window and enable the update mode.
When building a datawindow from a table (not a view), these settings seem to be the default.

And they said this stuff was gonna to be easy!!!!

>Greetings,
>
>Has anyone tried accessing DB2 tables from PowerBuilder
>via an Oracle Transparent Gateway?
>
>I am using:
> PowerBuilder 5.02 (16bit)
> Oracle 7.1 Database
> Oracle 7.2 Client (16bit)
> Win95
>
>I can see the DB2 tables if I create views for them on Oracle.
>I can create a datawindow for the table.
>I can update the table from the Database Admin window.
>
>I CANNOT update the table from the Database Painter.
>I CANNOT update the table from a datawindow within an application.
>
>From within the application the message is:
> 'Datawindow does not have update capability'
>
>I suspect the problem stems from PB not seeing the INDEX for the
>table.
>(PB does not allow the update of a table which does not have an
>index.)
>(The Properties Dialog for the table does not show an index.)
>
>Any ideas for getting around this would be GREATLY appreciated!!!
>
>Thanks - Dan
Received on Thu Feb 06 1997 - 00:00:00 CST