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 |
Explain the EXPLAIN statement?
Give the COBOL definition of a VARCHAR field.
How does one remove entries from the SCT02 table?
how will you retrieve first record in table
How to find schema of a table in db2?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
How to resolve -504 sql code in DB2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
Mention the different locking levels that are available in db2.
What is db2 command?