topic Re: Data load and SQL Statements in QlikView

Data load and SQL Statements

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Does anyone know if the "global" NOLOCKS statement -- SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED can work within the script?

Thanks

Josh

Re: Data load and SQL Statements

vishsaggi — Fri, 14 Oct 2016 21:30:52 GMT

I presume anything you write after SQL should work accordingly. Sorry If i have misunderstood your question. Correct me if I have ?

LOAD *;

SQL SELECT .......

FROM ...... ;

Re: Data load and SQL Statements

jduenyas — Fri, 14 Oct 2016 21:41:10 GMT

Thanks.

I should have tried it first before bothering y' all. But some good came out of it. If anyone else reads this now they know that it is OK to add the global nolock after the SQL...

SQL

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Select *

from your datasouce;