I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
1644before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
IBM,
1702what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
IBM,
2 5355suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
IBM,
5 8981If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
IBM,
1 5948
What is the difference between bind and rebind in db2?
Explain correlated sub-queries.
Differentiate between cs and rr isolation levels? Where do you specify them?
What do you mean by cursor?
How do you find the maximum value in a column in db2?
What is clone table?
Is it possible using max on a char column?
What is db2 stogroup?
What is rebind in db2?
How to create db2 table in mainframe?
How to find schema of a table in db2?
what is a corelated subquerry?
What is dbrm? What it contains?
What is the physical storage length of time data type?
Explain db2.