InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do You Assign The Transaction Object To The Dw Control? |
|
Answer» We use SETTRANS() or SETTRANSOBJECT(). When we use SETTRANS(), the DW CONTROL uses its own Transaction OBJECT and automatically performs connect, disconnect, commit and rollback. The SetTransObject() TELLS the DW control to SHARE the transaction object with other DW CONTROLS. We have to control the database processing and we are responsible for managing database transactions. Application performance is better when we use SetTransObject(). We use SETTRANS() or SETTRANSOBJECT(). When we use SETTRANS(), the DW control uses its own Transaction object and automatically performs connect, disconnect, commit and rollback. The SetTransObject() tells the DW control to share the transaction object with other DW controls. We have to control the database processing and we are responsible for managing database transactions. Application performance is better when we use SetTransObject(). |
|