-811 error



IBM's flagship relational database management system

-811 error

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

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

Re: -811 error

 

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
Akatsukami
Global moderator
 
Posts: 1053
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
GuyC
 
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
prino
 
Posts: 536
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 21 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.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: -811 error

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

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 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
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post