What is the difference between TYPE 1 index & TYPE 2 index
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
| Is This Answer Correct ? | 20 Yes | 4 No |
How do you eliminate duplicate values in db2?
How can we read records for specific member in CL? AND rpg?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
When is the results table for the query in a DECLARE CURSOR statement created?
What is the use of db2 optimizer?
Is it possible to precompile if db2 goes down?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is a recovery log?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is temporal table in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is a trigger in the db2 database?