You are viewing limited content. For full access, please sign in.

Question

Question

Workflow query data activity table lock

asked on February 10, 2014

 When workflow is performing a query data activity, is the table being queried locked? If I want to query a table without locking the table, will I need to write a custom query with the syntax to not lock the table?

Thanks.

0 0

Answer

APPROVED ANSWER
replied on February 10, 2014

The Query Data activity is just a simple wrapper that translates the parameters you enter in the UI into a SELECT statement that gets sent to the database. Other than minor differences in style, there will be no difference between the query built by the activity and one you'd write yourself.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.