I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
2065before 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,
2180what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
IBM,
2 6398suppose 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 10829If 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 6683
What is database reorganization?
What's The Error Code For Unique Index Voilation?
Explain what are the various isolation levels possible?
What is db2? Explain.
How do I add a column to an existing table in db2?
What is bind in db2?
How do I delete a table in db2?
Explain dclgen.
What is ibm db2 used for?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
what is a corelated subquerry?
How can deadlocks be resolved?
How do we specify index to include or not during bind process.
What are db2 tables?