|
|
Archives of the TeradataForum
Message Posted: Wed, 15 Jul 2009 @ 20:24:26 GMT
Subj: | | Generate always identity question |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, July 15, 2009 16:05 -->
Hi all,
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.
| |