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???