I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements.
I used information from this site as a reference for these statements but I must be doing something wrong.
UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT B.B1N4CD FROM DABCON2/VDA_CS B WHERE A.B1LWNB = B.B1LWNB) [em]Null values not allowed in column or variable B1N4CD. [/em]
(2nd attempt trying to handle null value)
UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = COALESCE(SELECT B.B1N4CD FROM DABCON2/VDA_CS B WHERE A.B1LWNB = B.B1LWNB) [em]Token B was not valid. Valid tokens: ) ,.[/em]
Any help will be appreciated!
May 19, 2011 3:39 PM
April 6, 2012 9:36 PM