Input Tool - Avoid Locking Up Database (Dirty Read)

[Lindsay_Wang]

Hi, 

I'm wondering if there are ways to avoid locking up ODBC (SQL) database when using SQL in the input tool?

I would do this in SQL by capping my query with "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" + Query + "COMMIT", but this seems to give errors with the SQL editor in Input Tool. 

Is the above supported in the Input Tool at all? If not, is there another way I could try?

[jrgo · Accepted solution]

Hi @Lindsay_Wang 

There is this option in the Input tool... not sure if that's available on all DB sources (this is to MS SQL Server).

If using SQL Server, adding the table hint with (nolock) works also.

SELECT *
FROM dbo.mytable WITH (NOLOCK)

[Lindsay_Wang]

this works well! thank you