Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74554 Views
- Accenture, CTS, TCS, I also Faced
- E-Mail Answers
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 |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to resolve -805 error in DB2?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is Reorg Recovery? when will you run it?
When is the skeleton cursor table created?
What is a Resource Control Table(RCT)? Describe its characteristics.
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What are types of indexes?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is correlation names?
What is the clustering index in the db2 database?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
COBOL 
