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 want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What does db2 plan contain?
What are the 2 sqlcodes that are returned?
What is a buffer in memory?
How do you retrieve the data from a nullable column?
How can you split a table in to exactly half?
What does DML stand for and what are some examples of it?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is consistency token in db2?
What is the difference between Primary key and unique index?
What is check constraint in db2?