What is sqlcode -811?

Answers were Sorted based on User's Feedback



What is sqlcode -811?..

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

What is sqlcode -811?..

Answer / kshitij

Without the use of cursor fetching two or more rows.

Is This Answer Correct ?    52 Yes 6 No

What is sqlcode -811?..

Answer / rami reddy

If single select returns more than one row then you get
SQLCODE = -811

Is This Answer Correct ?    38 Yes 3 No

What is sqlcode -811?..

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

What is sqlcode -811?..

Answer / toms k jose

multiple rows retrieved.

Is This Answer Correct ?    8 Yes 0 No

What is sqlcode -811?..

Answer / bruno

Registro duplicado na tabela DB2

Is This Answer Correct ?    1 Yes 4 No

What is sqlcode -811?..

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

Post New Answer

More DB2 Interview Questions

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


How to handle null values in db2

4 Answers  






Explain the contention situations caused by locks?

0 Answers  


What is JOIN and different types of JOIN.

2 Answers   IBM,


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


How to find the number of rows in db2 tables?

0 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


What are iseries servers?

0 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


Categories