I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
2109before 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,
2219what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
IBM,
2 6508suppose 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 10992If 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 6746
What is db2 stogroup?
what is the role of the cursor in db2?
How to create db2 table in mainframe?
What is dclgen (declaration generator)?
Explain dclgen.
Explain about rct.
What is a storage group (stogroup)?
What is buffer pool?
What is db2 bind?
How can you do the explain of a dynamic sql statement?
What is a cursor in programming?
What is a bind in db2?
What is a db2 tablespace?
How can we read records for specific member in CL? AND rpg?
What db2 400?