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

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


What is a subselect? Is it different from a nested select?

1 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


What is a storage group (stogroup)?

0 Answers  






Once you create a view, where would information about the view be stored?

1 Answers  


how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,


How to fetch the last row from the table in SQL (db2)?

0 Answers  


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


how to resolve -811

2 Answers   IBM,


Categories