Re: Problems Updating via DB link to AS400/DB2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGaFP+Lw8L4IAs830RAhdBAJ0Quph4SHLlrwqvCOc1TEen9YYX7ACggrVN TVADjJ3wpxBDUlHcb8DpQTw=
=RK9j
-----END PGP SIGNATURE----- Received on Thu Jun 07 2007 - 13:52:46 CDT