On the create tablespace, what does the CLOSE parameter do?
Answer / s
CLOSE YES parameter tells DB2 that when DB2 needs to close
datasets when DSMAX is reached, DB2 will choose this
tablespace to be closed.
Is This Answer Correct ? | 3 Yes | 0 No |
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. TIA
What's the maximum number of characters that a tablename can have?
Can one database have multiple instances?
How do you retrieve the data from a nullable column?
How does DB2 use multiple table indexes?
Define buffer pool.
Describe the elements of the SELECT query syntax?
What is the difference between spufi and qmf?
What is a cursor?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Can SQL statements/queries be included in a copybook?
What is package in db2 mainframe?