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 />
aka.