Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aniruddhyadutta
New Contributor

Does Qlikview lock tables during load??

I am having a Oracle table on which my incremental app is running (insert/update both)

I am missing records which are getting updated at time when qlik is reading the database.

Is that Qlik locks the database while reading and not able to pick up  records  which are  inserted during the readtime?

2 Replies
lakshmikandh
Valued Contributor II

Re: Does Qlikview lock tables during load??

QV only passes through the SQL SELECT to the ODBC driver. The ODBC driver and the target DBMS control locking.

Does Qlikview lock tables during load??

rwunderlich

mov
Esteemed Contributor III

Re: Does Qlikview lock tables during load??

It does, but you can use NOLOCK option in your SQL.