is it possible to get -811 error when you use cursors. why?
Answers were Sorted based on User's Feedback
When you are fetching cursor without declaration.
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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?
What is catalog database in db2?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is the use of db2 optimizer?
How do I connect my db2 database to ibm?
What is netezza database?
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?
When do you specify the isolation level?
What does sqlcabc has?
How to compare data between two tables in db2?
Explain in brief how does db2 determine what lock-size to use?
What is dbrm? What it contains? When it will be created?