Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
QV only passes through the SQL SELECT to the ODBC driver. The ODBC driver and the target DBMS control locking.
It does, but you can use NOLOCK option in your SQL.