What is reorg and runstats in db2?
No Answer is Posted For this Question
Be the First to Post Answer
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is load replace in db2?
What is difference between alias and synonym in db2?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How is the value function used?
Define declaration generator (dclgen).
What are data types?
What is db2 plan table?
What are union and union all?
What is database manager in db2?
What is lock contention?