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.
- 0 Answers
- 1238 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What are leaf pages?
How can you count the number of rows from a table tab?
how will you retrieve first record in table
I use CS and update a page. Will the lock be released after I am done with that page?
What is commit in db2?
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?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is a bind card?
How many Buffer pools are there in DB2 and what are they?
COBOL 
