Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2011 @ 19:51:46 GMT
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?
Juan Manuel Montero Luque
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|