what happend with out using Commit,when closing cursor and
program?
Answer Posted / praveen
If the program ran successfully, then it will commit.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What parameters are used to control the free space in DB2?
What is the difference between spufi and qmf?
What is a collection in db2?
What is multi row fetch in db2?
How do I create a view in db2?
Is the primary key a clustered index?
What is db2 stogroup?
What is dbrm library?
Explain about rct.
What is the difference between cursor and select statement?
What is load replace in db2?
How to check sequence on a table in db2?
How do I add a column to a table in db2?