Hi,

good days!
Below is my sql query:
UPDATE SUMMARYEVENT SET INITIALIZED = 1 WHERE SUMMARYTYPE = 2

Then, I got this error message:
Statement Failed, SQLCODE = -811

multiple rows in singleton select

However, if I use the same query with different summary type, eg
UPDATE SUMMARYEVENT SET INITIALIZED = 1 WHERE SUMMARYTYPE = 3

Then, the query executed successfully.
Can anybody explain this ? Please help.

rgds, Chooi Ting