DB2 Update Statment

JDionne · #1 (**permalink**) 01-11-05, 10:28

My code as fololows

Code:

update DB2ADMIN.DW_WQAS_ALL_TBL
set Multi_flag = (select 'M' 
		from db2admin.dw_wqas_all_tbl dw , session.wqas w
		where dw.contno = w.contno);

I need to update a base table (db2admin.dw_wqas_all_tbl) to mark multipile instances of a container number. When I run this code I get the following error.

Code:

SQL0811N  The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.

This makes sence because there are mulitpile records in the base table. How do I get around this?

n_i · #2 (**permalink**) 01-11-05, 10:32

How about this?

Code:

update DB2ADMIN.DW_WQAS_ALL_TBL dw
set Multi_flag = 'M' where exists (select 1 from session.wqas w
		where dw.contno = w.contno);

JDionne · #3 (**permalink**) 01-11-05, 10:35

Quote:

Originally Posted by n_i

How about this?

Code:

update DB2ADMIN.DW_WQAS_ALL_TBL dw
set Multi_flag = 'M' where exists (select 1 from session.wqas w
		where dw.contno = w.contno);

Sweetness!!!!!! Worked like a charm.
Thanx

Internet Services

Web Development

Digital Marketing

Consumer Tech