Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6269 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is coalesce in db2?
What is dclgen (declaration generator)?
Which component is responsible for processing sql statements and selecting access paths?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to find primary key of a table in db2?
How to check last update on table in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain correlated sub-queries.
Explain about cursor stability?
Why cursor is used in db2?
How can we read records for specific member in CL? AND rpg?
Is the primary key a clustered index?
What is netezza database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the difference between using bind () and rebind () methods of naming class?
