Answer Posted / s
Isolation level determines how long the page or row locks
will be held.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between using bind () and rebind () methods of naming class?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Where do you specify them?
What do you mean by rollback?
What do you mean by between and in? Is between inclusive of specified range values?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Why do we bind in db2?
How can record locking be achieved in those DB2 versions which do not support it?
How do I add a column to an existing table in db2?
What is the role of the data page in the db2 database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is sqlca?
What is the difference between dbm cfg and db cfg file in db2 ?
What is drop table?
what is a corelated subquerry?