EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Answer Posted / s
Non-matching index scan
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How does cobol compile db2 program?
What type of database is db2?
What is the difference between drop table and delete table?
How is a typical db2 batch pgm executed?
What is the purpose of rollback and commit?
Name the various locking levels available?
What is the result of open cursor statement?
How does coalesce work?
What is check constraint. Explain with example.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How do I add a column to a table in db2?
How to find the number of rows in db2 tables?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is dbrm in db2 database?
What is an instance in db2?