I'm a newbie to SQL in general and the searches I've done here haven't given me the right answer so I thought it would be worth posting this.

I have a DB2 table with multiple rows and columns. I'm trying to write an SQL statement that will allow me to update a single column in a specific row in that table.

I can't seem to find the correct syntax for the DB2 update command.

example:

update COLUMN2 of ROW1 in TABLE1 where COLUMN1="a specific value that I will provide"

any help would be appreciated.

Thanks.

update TABLE1 set COLUMN2 = 'X' where COLUMN1= 'Y'

If the columns are defined as numeric data types, then omit the single quotes. In order to ensure that only one row is updated, COLUMN1 would have to contain unique values (preferably have a unique index or PK defined on the column).

I will try these and report back if they are not successful.

Thanks for the help.

Mike