Update all the col4 values to match A table

chandu.be · New User Joined: 17 Jul 2006 Posts: 9 Location: Bagalore

Hi,

I have the following requirement:

I have two tables A & B. Both A & B are having the same columns 'col1', 'col2' and 'col3'. ('col1', 'col2' are part of primary key).
There are some rows in B table where col3 is not matching with A table.
So i need to write an SQL to update all the col4 values to match A table.

I tried the following query:
UPDATE B
SET COL3 = (SELECT COL3
FROM A WHERE A.COL1 = B.COL1 AND A.COL2 = B.COL2
AND A.COL3 <> B.COL3);

But it is giving me SQLCODE -4700.

Please help me.

Thanks & Regards,
Chandu

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

¿SQLCODE -4700? If I'm not wrong that's not a valid sqlcode...

chandu.be · New User Joined: 17 Jul 2006 Posts: 9 Location: Bagalore

Hi Acevedo,
SQLCODE -4700 is a valid code.

SQLCODE -4700 says that 'ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE'

Thanks & Regards,
Chandu

ashimer · Posted: Thu Apr 24, 2008 4:35 pm

This happens if you are using DB2 version 8 ... contact ur DBA and tell them to activate the new function mode or else try binding the program
with parameter NEWFUN(YES) ...

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

yes, here we have versin 7 and this is what you get when invoke dsntiar with -4700.

Bharath Bhat · Posted: Fri Apr 25, 2008 4:07 pm

Hi,