I have a main program (A) where we delete some rows in
table in a cursor, and we commit it in sub program(B).
What will happen - will we get an error or not?
Answers were Sorted based on User's Feedback
Answer / manikanta
Whenever control is going to sub program or control is coming back to main program - COMMIT takes place automatically by the system.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ananth
I dont know about this question?
Please let me know if you gave answer
Is This Answer Correct ? | 0 Yes | 2 No |
What does DSNDB07 database do?
How to find the number of rows in db2 tables?
What is -904 sql code? How to resolve it?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
How do you find the maximum value in a column in db2?
What is the difference between nvl and coalesce?
Q4. How will you get the count of record without using COUNT verb in query?
Explain the contents that are a part of dclgen.
What are the various locks available?
How do I copy a table in db2?
What are the bind parameters ibm db2?
How does a cursor work?