Discussion

1637
Views
Close popover
DILIP MONDAL (DilipKMondal)
Cognizant Technology Solutions

Cognizant Technology Solutions
CA
DilipKMondal Member since 2012 14 posts
Cognizant Technology Solutions
Posted: February 17, 2015
Last activity: February 17, 2015
Closed

Troubleshooting deferred write operations

(1) debugging

As a debugging aid, the standard HTML rule @baseclass.DeferredOps interrogates system internals and presents an ordered list of deferred (uncommitted) database operations for the current Thread. In a step immediately before a Commit method, your activity can display this HTML rule using the Show-Page method, to see what will be committed.

 

(2)  Oracle DB Level

Two Options:

    Initially immediate(default) - constraint validated at statement level
    Initially deferred - constraint validated at commit level

 

For deferred write operations, please use the 2nd option foreign key(Child Key)

 

ALTER TABLE <<Table>> ADD CONSTRAINT <<FK_Name>>

    FOREIGN KEY ("Column_Name_PK") REFERENCES <<Schema_Name.Parent_Table>> ("Column_Name_PK") ENABLE
    INITIALLY DEFERRED DEFERRABLE;

 

 

Data Integration
Moderation Team has archived post