Answer Posted / krishnaveni
commit is used to save the previous dml(data manipulation
language ex:insert,upadte,.) statements
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is db2 catalog database?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can record locking be achieved in those DB2 versions which do not support it?
What kind of database is db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to take backup of table in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do I import a csv file into db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is dbrm in db2 database?
define clustering index.
Why cursor is used in db2?
What is the use of runstats in db2?
can we view the access paths created by dbrm ? how ? thx
How do you select a row using indexes in db2?