Data load and SQL Statements

[jduenyas]

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

Thanks

Josh

[vishsaggi · Accepted solution]

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 ...... ;

[jduenyas]

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;