What is PRIME TABLE and what are the uses of it
Answer / poonam
Prime Double Hash Table always uses prime number table sizes. The table is expandable, and the cost of rehashing is amortized across each insertion or deletion operation
| Is This Answer Correct ? | 0 Yes | 0 No |
what is cursor stability?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What are the contents of a DCLGEN?
How to view db2 table structure?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Define check constraint.
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 is ALTER ?
What is the use of dclgen in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of db2 optimizer?