tDBCommit

[jimbo20814]

Please consider the below. The first subjob you can see it writes to Fact_TimeSlotMeeting. But see how the commit doesn’t occur until after the second subjob. See how Fact_TimeSlotMeeting is used in the second subjob.

So if records were inserted in first subjob, will those new records be there in second subjob even though the commit isn’t until after the second subjob?

[Anonymous · Accepted solution]

Hello @mbocquet,

Yes, if you are using the same connection (for example using the tDBConnection), the records inserted in the first subjob will be available in the second. The "OnSubjobOK" that you used in the "Stg_Lenses" and "Fact_TimeSlot" also help you with this, because will wait for the insert to be executed before the select statement.

Luiz Ramos