What is Declaration Generator(DCLGEN)?
Answer / ms. stanley
DCLGEN, as it is called, Contains the table Description and
the Field Names for the program to access the DB2 table
| Is This Answer Correct ? | 2 Yes | 0 No |
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 are the different types of base tables?
What is the difference between Primary key and unique index?
What does db2 blu stand for?
What is a cursor and what is its function?
What is dclgen (declaration generator)?
Can one database have multiple instances?
When do you specify the isolation level? How?
What is image copy in db2?
Explain how can you do the explain of a dynamic sql statement?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE