Simultaneous Read write data from database and qlikview
Hi All,
Is there anyway we can identify that database table is writing so qlikview need to wait while reading data from that table.
For now i am checking with NoOfRows() but, is there any other way that if database table is truncated or data write is not completed then qlikview should skip loading specific table and continue with other tables
This is usually taken care by the DBMS or OS upto some extend. Generally, if a table is being written to, it would be locked and read operation would not be allowed to leave users not be worried about the data inconsistency. Qlik user or any tool reading from it for that matter should not have to be worried about it.
But,in this case when db is writing table and simultaneously qlikview is reading then it will override existing qvd with 0 records that i want to avoid.
An alternatively might be to send an error-message drom the db to Qlik if the table is locked and using then ERRORMODE to fetch the error. But I think it's not easier than your noofrows() approach - at least within the first step because you might create some kind of loop repeating the query n times and waiting n seconds between the iterations before skipping the task.
No there is not. The db must create an error-message and the used sql-driver must transfer them and then you could fetch them with a query on the ScriptError variable.
