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

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  






What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  


What is dynamic SQL?

1 Answers   ADP,


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


What is referential integrity?

5 Answers  


What is catalog database in db2?

0 Answers  


What is multi row fetch in db2?

0 Answers  


Categories