What happens when more than one row satisfies a Select statement that is executed outside of any cursor processing?

Questions by pavanreddy.y

Showing Answers 1 - 12 of 12 Answers

sainathkb

  • Jul 25th, 2008
 

if select statment retrieving the more than one row, without using cursor concept then

thier may bea chance of space error.

and program will abend with -811 error.

To aviod -811 error, please use cursor concept.

kalone

  • Jan 31st, 2010
 

If such situation occurs, the values of the frst row will be placed in the host variable and DB2 will issue -811 abend code.

  Was this answer useful?  Yes

pawan_singh

  • May 14th, 2010
 

If you using just a simple select SQL statement and it is giving you more than one row as output than you will get a SQL code retrun -811. To avaoid this depending your requirement you can modify your query or if you need more than one row than just use cursor.

Thanks
Pawan

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions