Re: Problems Updating via DB link to AS400/DB2

ahogan wrote:
> 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

para.mfam_at_TEST may be a view rather than a table. Try these:

SELECT object_type
FROM all_objects_at_TEST
WHERE owner = 'PARA'
AND object_name = 'MFAM';

and

SELECT column_name, updatable, insertable, deletable FROM all_updatable_columns
WHERE owner = 'PARA'
AND object_name = 'MFAM';

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org