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's the best lock size that you could use when you create a tablespace?
What are bind parameters in db2?
What are the three types of page locks that can be held?
What is the syntax of SELECT statement when embedded in a COBOL program?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is a Resource Control Table(RCT)? Describe its characteristics.
How to find the number of rows in db2 tables?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What does the CHECK Utility do ?
How do I connect my db2 database to ibm?