Update multiple row in SQL

[Iceberg]

Hi All can anyone help with the below scenario that i need to update...

FileA
Field1	Field2	Field3
A	B	I
A	B	*Blank
A	B	*Blank
C	D	O
C	D	*Blanks
C	D	*Blanks
C	D	*Blanks
C	D	*Blanks

So I need to update all A /B with value I which are *blank and C/D with O which are *blank. So any DB2 query to do the same

Thanks

[Brian Rusch]

How about this:

update File
set Field3 = case when Field1 = 'A' and Field2 = 'B' then 'I'
                  when Field1 = 'C' and Field2 = 'D' then 'O'
                  else ' ' end
where Field 3 = ' '

[Brian Rusch]

* where Field3 = ' '

[Iceberg]

Hi Brian Thanks for the response, Actually Consider field1 and field2 as composite key, so there can be so many keys like A/B and C/D, So i cant make it hardcode like this.

[Iceberg]

want to update blank with I if Field1/Filed2 is A/B.

[Iceberg]

I mean a generic query

[Iceberg]

Rite now am using below query but not correct:-
Update FileA as A set A.Field3=(Select B.Field3 from FileA as B where A.Field1=B.Field1 and A.Field2=B.Field2 and A.Field3<>' ' and B.Field3<>' ') where
Exists (Select 1 from FileA as B where A.Field1=B.Field1 and A.Field2=B.Field2 and A.Field3<>' ' and B.Field3<>' ')

But this query only updating rows where Field3 not *Blank.

[B.Hauser]

IMHO you have to change

A.Field3<>' ' and B.Field3<>' '

to

A.Field3 = ' ' and B.Field3 <> ' '

Birgitta