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 -> Re: Update via dblink 10.2.0.1 - AS400/DB2 (v5r2)

Re: Update via dblink 10.2.0.1 - AS400/DB2 (v5r2)

From: Jeroen van den Broek <nltaal_at_baasbovenbaas.demon.nl>
Date: Fri, 22 Jun 2007 07:09:44 -0700
Message-ID: <1182521384.118913.18020@u2g2000hsc.googlegroups.com>


On Jun 22, 3:18 pm, ahogan <hoganA..._at_gmail.com> wrote:
> 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.

Hmm, I don't think this is the EXACT statement that you succesfully ran, considering 'para/mfam' vs. 'para.mfam' ...

>
> 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.
>

Basically the SQL0204 indicates that an object doesn't exist, in this case 'MFAM'.
And although you state you are using the exact same userid, I am wondering about the 'en QGPL' part of the error message. I am not familiar with DB2 on AS400 or its error messages, but I guess it indicates that the dblink tries to update table 'MFAM' in schema 'QGPL' i.s.o. 'PARA'.

HTH

--
Jeroen
Received on Fri Jun 22 2007 - 09:09:44 CDT

Original text of this message

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