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