What is a DB2 access path?
Answer / guest
It is used to determine efficient way to access db2 tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
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.
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is Call attach facility? How does it work?
Name the lockable units in DB2?
why we go for SPUFI for creating tables or for sql queries?
What is load utility in db2?
Is db2 a database?
What is the STOSPACE Utility used for?
What can the SET option of the Repair Utility accomplish?
What are common abends
How do I optimize a query in db2?
What is a db2 schema?