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 |
Which is faster delete or truncate?
what is the input to PLAN? what is the input to DBRM?
How will you return the number of records in table?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is the use of db2 optimizer?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Which catalog table stores referential constraints?
How to take backup of table in db2?
What does sqlcabc has?
Is db2 relational database?
What is a buffer pool?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?