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 the responsibility of the construction superintendent
How do I delete a table in database?
What is buffer pool and list some of them?
What is the use of db2?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is a precompiler?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is db2 connect?
wht is d/f between union and joins ?
How would you find out the total number of rows in a db2 table?
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.
How can you quickly find out the number of rows updated after an update statement?