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
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.
What is a Resource Control Table(RCT)? Describe its characteristics.
What is a subselect? Is it different from a nested select?
Can we use select * statement in cobol program without giving field names ???
What is a storage group (stogroup)?
Once you create a view, where would information about the view be stored?
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
How to fetch the last row from the table in SQL (db2)?
Where besides the DB2 catalog is database object information stored by DB2?
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?
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?
how to resolve -811