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 |
What is DB2 (IBM Database 2)?
How does the processing of a correlated subquery differ from a non correlated subquery?
What is the difference between bind and rebind in db2?
What is copy pending status in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
what is the responsibility of the construction superintendent
What kind of database is db2?
What is a host variable?
Define buffer pool.
what is SMP/E? and what are the major steps of it? thanks...
How do you run JCL in cobol program