Answer Posted / raji
intent,shared,exclusive,update,bulk
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do I add a column in db2?
What is bind package and plan in db2?
what is the sqlcode -501
What db2 400?
What is runstats and reorg in db2?
Define declaration generator (dclgen).
What is the use of commit in db2?
How will you return the number of records in table?
How do you select a row using indexes in db2?
What is dbrm? What it contains?
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.
What is the difference between cursor and select statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?