Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2011 @ 19:51:46 GMT


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


Subj:   View accesing while loading table process
 
From:   Montero Luque, Juan Manuel

Hi everyone,

I'm trying to read data from a view while source table is been loading. I'm using fastload as load method.

My DDLs are like this:

     CREATE MULTISET TABLE T1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           COD_ANOMES INTEGER NOT NULL,
           COD_UNIDAD SMALLINT NOT NULL,
           TIM_FMODIFIC TIMESTAMP(6) NOT NULL) UNIQUE PRIMARY INDEX ISFMAHCN ( COD_ANOMES
     ,COD_UNIDAD  ); Replace view VT1 as  locking row for access mode nowait select * from T1;

supports teradata this kind of behaviour?


Regards,

Juan Manuel Montero Luque
Consultor
Soluciones Tecnolsgicas



     
  <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: 27 Dec 2016