By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,503 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,503 IT Pros & Developers. It's quick & easy.

Problems Updating via Oracle DB link to AS400/DB2

P: n/a
Previously posted on comp.databases.oracle.misc. Apologies to those
who read both groups.

I have created a link using generic connectivity from an Oracle
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:
SQLupdate para.mfam@TEST set pcau = 'dummy'
2 where cod=4281 and tip = 'P' and codu =2001;
update para.mfam@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 an Oracle error but I can't
find any definite suggesions or solutions.

Any ideas,

Regards,
Anthony Hogan

Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Jun 8, 2:46 pm, ahogan <hoganA...@gmail.comwrote:
Previously posted on comp.databases.oracle.misc. Apologies to those
who read both groups.

I have created a link using generic connectivity from an Oracle
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:
SQLupdate para.mfam@TEST set pcau = 'dummy'
2 where cod=4281 and tip = 'P' and codu =2001;
update para.mfam@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 an Oracle error but I can't
find any definite suggesions or solutions.

Any ideas,

Regards,
Anthony Hogan
Is the table on DB2-AS400 journaled? For this type of transaction the
table needs to be journaled.

Cheers,

Jun 10 '07 #2

P: n/a
On 11 jun, 00:27, "db2st...@gmail.com" <db2st...@gmail.comwrote:
On Jun 8, 2:46 pm, ahogan <hoganA...@gmail.comwrote:


Previously posted on comp.databases.oracle.misc. Apologies to those
who read both groups.
I have created a link using generic connectivity from an Oracle
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:
SQLupdate para.mfam@TEST set pcau = 'dummy'
2 where cod=4281 and tip = 'P' and codu =2001;
update para.mfam@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 an Oracle error but I can't
find any definite suggesions or solutions.
Any ideas,
Regards,
Anthony Hogan

Is the table on DB2-AS400 journaled? For this type of transaction the
table needs to be journaled.

Cheers,- Ocultar texto de la cita -

- Mostrar texto de la cita -
Thanks for the reply.
Yeah, we thought of that - the table is journaled.

This is a weird one. -I can select, insert and delete remotely but not
update. I can update when connected directly. Are there any session
logs I could check on AS400 that would give me a better idea of the
underlying error?

Regards,
Anthony Hogan

Jun 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.