Answer Posted / mainframe.rahulz
EXPLAIN stores output in PLAN_TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
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.
How to retrieve rows from a db2 table in embedded sql?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How to access db2 tables in mainframe?
What are the benefits of using the db2 database?
What is bind and rebind in db2?
What does db2 stand for?
What do you mean by cursor?
What is db2 optimizer?
What is query_cache_limit?
How many databases are there?
What is the maximum number of columns in a db2 table?