Page 1 of 1

-811 error

PostPosted: Thu Jun 07, 2012 2:34 pm
by surime72
hi
while i was running pli-db2 program showing error as -811

Re: -811 error

PostPosted: Thu Jun 07, 2012 2:59 pm
by Akatsukami
That's too bad.

Re: -811 error

PostPosted: Thu Jun 07, 2012 6:33 pm
by GuyC
While i was running a person was showing his bottom

Re: -811 error

PostPosted: Thu Jun 07, 2012 7:11 pm
by prino
While I saw this post, our cat was scratching itself.

Re: -811 error

PostPosted: Thu Jun 07, 2012 7:16 pm
by NicC
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.

Re: -811 error

PostPosted: Thu Jun 07, 2012 8:39 pm
by dick scherrer
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. . .

Re: -811 error

PostPosted: Wed Jun 20, 2012 11:16 am
by Anuj Dhawan
ROFL - this is funny. But this is a Beginners Forum, so I'll go little slow... :D

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