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 |
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
what is difference between Static call and Dynamic call? How does it function?
What is COPY PENDING status?
What is usage pointer in cobol?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are db2 objects?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How can we retrieve the total number of records in RPG & CLLE?
How to view db2 table structure?
What is a Database Request Module(DBRM)?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)