0 - 1 of 1 tags for queue table

Earlier last year, there was a post on this forum asking loop function in BTEQ, this post will also show a trick how to "mimic" a loop using BTEQ.

Recently, I encountered a particular issue in our environment. A process using parallel BTEQ scripts to process data and target to the same destination. Generally, there will be multiple insert/update/delete in each script targeting at one main target table. At first glance, there should be no issue, since RDBMS manage locks and will leave the session in "blocked" state and serve the request FIFO.