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
2073by 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 9231the 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 6192
What type of database is db2?
Explain about mirror activator disk mirroring?
is it compulsory commitment control in journal?
What is dbrm in db2 database?
Are views updateable?
What are foreign keys in db2?
Mention the definition of cobol in varchar field.
What is the advantage in De-normalizing tables in DB2?
How and when does the db2 enforces the unique key?
What is db2 optimizer?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain the contents that are a part of dclgen.
What is the picture clause of null indicator variable?
What do you mean by cursor?
Which isolation level provides highest data integrity?