AnsweredAssumed Answered

How does insert statement differ from insert child statement in DB profiles

Question asked by RanjiniElamkulammana2391 on Oct 24, 2016
Latest reply on Oct 25, 2016 by rahulgudimalla

Hi,

 

What is the difference between insert statement and insert child statement in DB profile. This is my assumption, if you want to perform a parallel commit, use insert statement (as a sibling to the first statement) or if its a parent-child relation go for insert child statement. But in either case, the operation will fail if any of the transaction fails. If this understanding is right, can i use a profile with a parent statement and a child statement to do the following.

 

1. Insert to the parent table first, if the insert is successful insert to the child table.

2. Can I do the same using a sibling statement???

 

Confused !!!

Outcomes