What is db2 and what is the use of db2 optimizer?
What is concurrency?
how do we solve soc 7 and soc4 ?
What is db2 bind?
What is the clustering index in the db2 database?
What is db2 stogroup?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
How can you get the number of rows impacted by the last executed query?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is subquery ?
B37 abend during spufi?
What do you need to do before you do EXPLAIN?
Name the various locking levels available?