Multi column updates

Posted in 2010

DHARMENDRA SHARMA — Fri, 01 Oct 2010 14:28:51 — source: IIUG Forums & Mailing Lists

Hi All, So far, I have been using following update to update all "int" columns and it was working okay. Yesterday, I changed the query to add a "char" column. For some reason, I got an error saying "cannot insert null value into column <charColumn>". Please note, there was a value from the fetched table. Also, to re-confirm, I replaced the column with another "char" column name and got the same error. Is this a limitation of multi column update? or I am missing a valid syntax here... At this point, I am asking this question as a common question for IDS versions that allow multi column updates and therefore not stating any specific version. If you still need it, please let me know. UPDATE tab1 SET (int_col_1, int_col_2, char_col_1) = (( select int_1, int_2, char_1 from tab2 where ......)) WHERE .....; As always, thanks in advance... Regards, Dharmendra