Re: Problems Updating via DB link to AS400/DB2

On 7 jun, 19:52, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:

> ahogan wrote:
> > I can execute Select, Insert and Delete statements via the link
> > without error. When I launch an update from sqlplus I get the
> > following error:
> > SQL> update para.mfam_at_TEST set pcau = 'dummy'
> > 2 where cod=4281 and tip = 'P' and codu =2001;
> > update para.mfam_at_TEST set pcau = 'dummy'
> > *
> > ERROR at line 1:
> > ORA-28500: la conexión de ORACLE a un sistema no Oracle ha devuelto
> > este
> > mensaje:
> > [Generic Connectivity Using ODBC][A055] The column 'PCAU' is not
> > updateable.
> > ORA-02063: 2 lines precediendo a TEST
>
> > I can execute the same sentence directly on DB2 without error (same
> > userid):
>
> > update para/mfam set pcau = 'dummy'
> > where cod=4281 and tip = 'P' and codu
> > =2001
> > 1 filas actualizadas en MFAM de PARA.
>
> Does the user, defined in the link, have the same rights as the
> user you can do the update with, directly in DB2?
> Oracle differentiates between insert, select, update and delete
> rights - you may have three of the required four.
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

> - Mostrar texto de la cita -

I am using the same user to create the link as I am to connect directly with DB2. The issue of permissions did occur to me so I created a second link using a DB2 user with more rights - same result.

Regards,
Anthony Hogan Received on Fri Jun 08 2007 - 01:55:03 CDT