IBM Mainframe Forum

hi
while i was running pli-db2 program showing error as -811

That's too bad.

While i was running a person was showing his bottom

While I saw this post, our cat was scratching itself.

While I was reading this I hope you were reading the manual, searching the web or consulting with your co-workers who will have had a lot of experience with this sort of thing.

Hello,

If you continue to post nothing people can use to help you, expect more "flaming" . . .

Have you yet looked up the meaning of the -811. The description is rather specific and you will need to correct the data or change the code. . .

ROFL - this is funny. But this is a Beginners Forum, so I'll go little slow...

-811 - is pretty straight forward, from the manuals - execution of an embedded SELECT statement or a subselect in the SET clause of an UPDATE statement has resulted in a result table that contains more than one row. Alternatively, a subquery contained in a basic predicate has produced more than one value.

So, in your program either handle SQLCODE -811, use CUROSR. Or may be if you can, use FETCH FIRST 1 ROW ONLY - but than what release of DB2 you are at? Hopefully not less than V7.