is it possible to get -811 error when you use cursors. why?

Answers were Sorted based on User's Feedback



is it possible to get -811 error when you use cursors. why?..

Answer / vaneesh khurana

When you are fetching cursor without declaration.

Is This Answer Correct ?    1 Yes 0 No

is it possible to get -811 error when you use cursors. why?..

Answer / purushothr

Yes it is possible only in cursor. if u trying to retrieve
more than one row at the same time by using cursor then -
811 error ll come.

Is This Answer Correct ?    6 Yes 14 No

Post New Answer

More DB2 Interview Questions

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


What is catalog database in db2?

0 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


What is the use of db2 optimizer?

0 Answers  


How do I connect my db2 database to ibm?

0 Answers  






What is netezza database?

0 Answers  


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,


When do you specify the isolation level?

0 Answers  


What does sqlcabc has?

0 Answers  


How to compare data between two tables in db2?

0 Answers  


Explain in brief how does db2 determine what lock-size to use?

0 Answers  


What is dbrm? What it contains? When it will be created?

0 Answers  


Categories