Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Update via dblink 10.2.0.1 - AS400/DB2 (v5r2)

Update via dblink 10.2.0.1 - AS400/DB2 (v5r2)

From: ahogan <hoganAPLP_at_gmail.com>
Date: Fri, 22 Jun 2007 06:18:59 -0700
Message-ID: <1182518339.236778.267800@o61g2000hsh.googlegroups.com>


The story so far..

I have created a link using generic connectivity from a 10.2.0.1 instance running on windows 2003 32 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)
Initially I thought it may be an ODBC or DB2 issue but further testing has shown... a) Update works via MSAccess/ODBC/DB2 b) Update works via JDBC c) Update works via dblink 8.1.7 ...which leads me to suspect that it is a 10G issue. Any pointers on where to look next would be appreciated. Regards, Anthony Hogan
Received on Fri Jun 22 2007 - 08:18:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US