|
| Re: How to update many rows at a time in DB2 |
 |
Fri, 23 Nov 2007 12:11:38 EST |
Hi,<br />
<br />
sqlcode -811 means, that the result of your SELECT on the right side of the =
operator returns more than one value, which cannot be assigned to one
field...<br />
<br />
You can see the full message with db2 ? sql-811 or search for SQL0811N in the
docs.<br />
<br />
So you would have to include your where clause also in the (sub-)SELECT to make
the result unique, or use the alternative technique which is explained in the
docs.<br />
<br />
Good luck,<br />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|