Archives of the TeradataForum
Message Posted: Wed, 15 Jul 2009 @ 20:24:26 GMT
<-- Anonymously Posted: Wednesday, July 15, 2009 16:05 -->
I create a table like this :
CREATE SET TABLE DB.LOAD_SIMUL (NO_SEQ INTEGER Generated ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 NO CYCLE), NO_TRY BYTE, REQUEST VARCHAR(7), DTS TIMESTAMP(2), DTE TIMESTAMP(2) );
I try to insert in this table with a insert request like this but it doesn't work :
insert into DB.LOAD_SIMUL SELECT something is wrong at this place 1 , SUBSTRING(QueryText,9,7) ,StartTime ,LastRespTime from DBC.QryLog where Username = 'dummy' and StartTime between '2009-07-13 14:54:00.00' and '2009-07-13 15:32:00.00'
Any information about good insert request will be appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|