Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problems Updating via DB link to AS400/DB2
I have created a link using generic connectivity from a 10.2.0.1
instance running on windows 2003 64 bit server to an AS400/DB2
database (V5R2 AFAIK).
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.
The HS trace file shows:
(0) [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0204 - MFAM
en QGPL
(0) de tipo *FILE no encontrado. (SQL State: S0002; SQL Code: -204) --
*FILE not found
(0) (Last message occurred 2 times)
(0)
(0) [A055] The column 'PCAU' is not updateable.
(0)
Google seems to indicate that this is not exclusively an Oracle error but I can't find any definite suggesions or solutions.
Any ideas,
Regards,
Anthony Hogan
Received on Thu Jun 07 2007 - 09:02:35 CDT
![]() |
![]() |