Interested to Buy Any Domain ? << Click Here >> for more details...
What is sqlcode -811?
- 7 Answers
- 74227 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 |
Suppose if I need to update a column, how you do that using cursor?
What is runstats and reorg in db2?
How can you display the current date & current time ?
What is lock escalation?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the STOSPACE Utility used for?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is DYNSLT keyword? How do you perform selection using DYNSLT
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 DB2 Catalog column tell you when an index needs table reorganized ?
Can SQL statements/queries be included in a copybook?
What does runstats do in db2?
COBOL 
