Archives of the TeradataForum

Message Posted: Mon, 13 Jun 2011 @ 09:05:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, June 13, 2011 04:53 -->

Dieter,

I have got information about pseudo table from "SQL Reference: Statement and transaction processing" manual.

My BATCHUSER id is used for insert select from multiple source table as a part of multistatement request.

Still, my question is: If one transaction (as a part of Multi statement request), is not complete and table is still in locked state then why 2nd transaction got started? By concept of pseudo table, it should get queued. Correct?

	<Prev	Next>		<<First	<Prev	Next>	Last>>