473,324 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Problems Updating via Oracle DB link to AS400/DB2

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
2 7215
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no...
100
by: Peter | last post by:
Company thought DB2 will be better than Oracle. The bottom line is when you do select, the system crash. I think it may take 4-5 years for DB2 to reach Oracle standard. Peter
0
by: Si | last post by:
Hi, I am having trouble with an install of Oracle 9i Release 2 on Linux Mandrake 9.1. I have 512 MB DDR RAM and a Duron 850 CPU. The install appeared to run fairly seamlessly except for a...
1
by: RTJ | last post by:
I have experienced problems with Oracle OCI library. I was unable to properly link OCI library using gcc. Probably gcc compiler provided with SFU is unable to link native Windows library. Oracle...
4
by: neptune | last post by:
I built a form that pulls several fields from a query. In some instances the field is empty and nothing displays in the form text box. In this case I want a simple statement like "Item Not...
2
by: neptune | last post by:
I currently link a table to an Oracle db. Anytime I open a query based off it, I have to input username & password. Is there a way to do this automatically? I'd prefer to use linked tables,...
2
by: phil03 | last post by:
Hi, I'm looking for some thoughts/guidance about the following scenario. A bit background first.... I have an Access database (BE) which has numerous linked tables connected to our company...
9
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to...
2
by: mdlwembe | last post by:
Hallo everyone. I am employed in an IT Department as a programmer. We use AS400 system. Due to economic changes we are faced with a currency change situation which will badly affect our database...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.