How to test SQL -911 error while developing COB-DB2 program
- 1 Answers
- 6682 Views
- Satyam, I also Faced
- E-Mail Answers
Answer / valmiki1980
1. put autocomit No in spufi and run insert command
2. run the insert command thru cob-db2 program.
this results -911 error
| Is This Answer Correct ? | 1 Yes | 1 No |
Mention the downsides of page level lock.
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What happens to the PLAN if index used by it is dropped?
How do I connect my db2 database to ibm?
How to find the number of rows in db2 tables?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is runstats and reorg in db2?
What are types of indexes?
What is a view? Why use it?
How many Buffer pools are there in DB2 and what are they?
Which component is responsible for db2 startup and shutdown?
What is declare cursor?
COBOL 
