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.
No Answer is Posted For this Question
Be the First to Post Answer
what is REORG? what is the use?
Give a brief description of db2 isolation levels?
List down the data types in the db2 database.
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the use of runstats in db2?
what is load and unload in db2
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the Isolation levels possible ?
How could one combine a set of incremental image copies into a single copy?
can we view the access paths created by dbrm ? how ? thx
Is db2 free?