How can you classify the locks in db2?
What is an instance database?
How do you select a row using indexes in db2?
What is RUNSTATS?
What is a collection in db2?
How does DB2 store NULL physically?
How would one remove old reorg information from the DB2 catalog?
Is db2 a mainframe database?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is the error code -803 ?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
what is the difference between where clause and having clause