How can you get the number of rows impacted by the last executed query?
What is difference between rollback and commit?
wht displays the number of times a query modified ?
define clustering index.
What is DCLGEN ?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
how to get duplicate records from tables?write qurey for this?
when does the SQL statement gets executed when you use cursor in the application programming ?
what is the process of precompiler?
What are foreign keys?
what is difference between Static call and Dynamic call? How does it function?
Is ibm db2 open source?
what is a corelated subquerry?