Answer Posted / mainframe.rahulz
EXPLAIN stores output in PLAN_TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the 2 sqlcodes that are returned?
Define db2.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is dbrm in db2 database?
How many types of page locks can be held in db2?
Explain about cursor stability?
What is nvl in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the maximum number of columns in a db2 table?
What is a cursor in programming?
What is copy pending and check pending in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
what is utility for parm lib
What is a db2 tablespace?
