Archives of the TeradataForum

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

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

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>>