ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
2021by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
4 9051the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
2 6089
How can we retrieve the total number of records in RPG & CLLE?
Explain about rct in db2?
What is copy pending and check pending in db2?
Explain what are the various isolation levels possible?
What is the function of logging in the db2 database?
What is the difference between using bind () and rebind () methods of naming class?
What is query_cache_limit?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is reorg and runstats in db2?
How many databases are there?
How do I add a column to an existing table in db2?
What is innodb buffer pool?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is db2 stogroup?