What is sqlcode -811?
Answers were Sorted based on User's Feedback
Answer / jdriley
Is the SQLCODE returned when your singleton select
statement returns/retrieves more than one row of data.
Is This Answer Correct ? | 68 Yes | 7 No |
Answer / kshitij
Without the use of cursor fetching two or more rows.
Is This Answer Correct ? | 52 Yes | 6 No |
Answer / rami reddy
If single select returns more than one row then you get
SQLCODE = -811
Is This Answer Correct ? | 38 Yes | 3 No |
Answer / bharani
We get error -811, when 'WHERE' criteria in singleton query
matched with multiple rows of a table, it can only fetch
and process one row at a time. Only way to avoid this error
by using cursor concepts.
Is This Answer Correct ? | 29 Yes | 1 No |
Answer / marek
The one correct answer is: "Look at DB2 doc." Who remember
all sql error codes?
Is This Answer Correct ? | 19 Yes | 40 No |
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is db2 connect?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the difference between CS and RR isolation levels?
What are data types?
What is the function of the Data Manager?
can all users have the privilage to use the sql statement select * (dml)?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What is the latest version of ibm db2?
What should be specified along with a cursor in order to continue updating process after commit?
Give a brief description of db2 isolation levels?
What is a cursor and what is its function?