When will you chose to run RUNSTATS?
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
| Is This Answer Correct ? | 4 Yes | 4 No |
List out the buffer pools in db2
What is meant by isolation level?
What do you mean by rollback?
explain about index with examples
How to run db2 command in windows?
Are views updatable ?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?