Extraction From Direct Database Causing Mismatch

[Gabbar]

Hi All, While Taking data direct from the server i encountered a problem, as the data is getting updated every second (Possibly much smaller than second), while extraction the table i extract have a data mismatch. my First two columns, submission time and last column  are from Table Application and the rest are from Table Obligation,
Both table are linked on reference.

In this, case the status is 3 which means Obligation should not be generated yet, but there is obligation number and Created time of obligation Lies during my reload time of extraction, 
when i went to database to Check status is 5, which means it was generated during the reload time of extraction and Table Application was extracted first and hence status is 3 and after that table Obligation was extracted resulting in this.


I want to know that if there is a way to Lock the database when i start reloading extraction from qliksense script only or any other way through qlik.
I cant depend completely on created on field as in many table, they might give error.

[Gabbar]

@vinieme12  
@Kushal_Chawda 

[Kushal_Chawda]

@Gabbar  Do you mean using DIRECT QUERY? Which database?

[Gabbar]

@Kushal_Chawda  yes while using direct query, Database is PostgreSQL

[Kushal_Chawda]

@Gabbar  As far as Know, DIRECT query pushes down query to underlying data in real time based on selection so I really don't understand the concept of extract here. Probably I would suggest to join both the tables in direct query so that when you apply selection query applies to both the table at same time.