What is the difference between TYPE 1 index & TYPE 2 index
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
Is This Answer Correct ? | 20 Yes | 4 No |
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What are the three lock types?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is filter factor?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are bind parameters in db2?
What is cursor in dbms?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is buffer pool and list some of them?