what happend with out using Commit,when closing cursor and
program?
Answer Posted / mani
The answer to the question is pretty simple and straight.
Auto commit happens when the cursor is closed.
If at all there is any abend then the changes made will be lost.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is null indicator in db2?
How to find primary key of a table in db2?
what is a corelated subquerry?
What are the full forms of spufi and dclgen and why are they used?
What is a db2 table?
What is lock escalation in db2?
What is the syntax for FETCH in DB2 ?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
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
Before you give the explain statement, what are the prerogatives?
What are db2 objects?
Are view updateable?
What is query_cache_limit?
What is the maximum size of varchar data type in db2?
How can you find out the # of rows updated after an update statement?