How to update multiple columns in single update statement in DB2

sql database db2 sql-update
Superman picture Superman · Mar 26, 2014 · Viewed 147.1k times · Source

I want to update multiple columns of a table in DB2 with single Update statement.

Any hint or idea will be appreciable. Thanks.

Answer

Gordon Linoff picture Gordon Linoff · Mar 26, 2014

The update statement in all versions of SQL looks like:

update table
    set col1 = expr1,
        col2 = expr2,
        . . .
        coln = exprn
    where some condition

So, the answer is that you separate the assignments using commas and don't repeat the set statement.

Related questions

Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this. SELECT DAYS (CURRENT …

Read More
Does DB2 have an "insert or update" statement?

From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. My code now does a select and if no result is returned it does an insert. I really don't …

Read More
Way to decrease column length in DB2

Is there a way to decrease the column length in DB2? Say I have a table temp with column col1 defined as VARCHAR(80). I want to reduce it to VARCHAR(60).

Read More