Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74595 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 |
When will you chose to run RUNSTATS?
What is reorg in database?
What is the self-referencing constraint?
pls tell me abt the normalization five types....
What DB2 Catalog column tell you when an index needs table reorganized ?
what is static sql? what is dynamic sql? Give me details
what happend with out using Commit,when closing cursor and program?
Can a array declared with an index be displayed(readable format) in spool?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What does db2 blu stand for?
What is the SQL Communications Area and what are some of its key fields?
Give the name of some fields form sqlca.
COBOL 
