-811 error

IBM's flagship relational database management system

-811 error

Postby surime72 » Thu Jun 07, 2012 2:34 pm

while i was running pli-db2 program showing error as -811
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: -811 error

Postby Akatsukami » Thu Jun 07, 2012 2:59 pm

That's too bad.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: -811 error

Postby GuyC » Thu Jun 07, 2012 6:33 pm

While i was running a person was showing his bottom
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: -811 error

Postby prino » Thu Jun 07, 2012 7:11 pm

While I saw this post, our cat was scratching itself.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
Posts: 639
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 29 times

Re: -811 error

Postby NicC » Thu Jun 07, 2012 7:16 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: -811 error

Postby dick scherrer » Thu Jun 07, 2012 8:39 pm


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. . .
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: -811 error

Postby Anuj Dhawan » Wed Jun 20, 2012 11:16 am

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.
Anuj Dhawan
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post