Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Pseudo table and deadlock for BATCHUSER
From:   Anomy Anom

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


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023