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 SALTABLE1365
by 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 6673
Which one allows duplicate values Union or Union All ?3 5797
Can you Average the Characters ?3 4252
What is DCLGEN ?3 6501
what is SPUFI ?2 5910
Name some fields from SQLCA1 5069
What do you need to do before you do EXPLAIN ?1 3836
What are the Isolation levels possible ?5 5575
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd12 4576
What is table space in db2?
What is host variable?
What are host variables in db2?
How to test SQL -911 error while developing COB-DB2 program
What is the physical storage length of time data type?
What are packages in db2?
How will you return the number of records in table?
What is schema in db2?
Is db2 a mainframe?
Why cursor is used in db2?
What is a db2 package?
What is dclgen (declaration generator)?
What is syscat in db2?
What action db2 takes when a program aborts in the middle of a transaction?
How do we specify index to include or not during bind process.