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

Post New Answer

More DB2 Interview Questions

How does DB2 use multiple table indexes?

1 Answers  


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  


Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  


Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,






What does a deadlock mean in DB2?

0 Answers  


What is the difference between oracle and db2?

0 Answers  


What is an instance database?

0 Answers  


Mention some fields that are a part of sqlca.

0 Answers  


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


What does the REORG Utility do?

2 Answers  


How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,


Categories