Archives of the TeradataForum
Message Posted: Fri, 05 Aug 2005 @ 11:50:16 GMT
Can anyone tell me what I'm doing wrong with this (simple) import command ?
INSERT INTO DEVG123AHE.EXCHANGEGROUP VALUES (?,?,?,?,?,?);
The data in the file looks like this :
'YR','2005-08-05','2060-12-31','EUR','2005-08-05 11:40:49','CLOUGH' 'MT','2005-08-05','2060-12-31','GBP','2005-08-05 11:40:49','CLOUGH'
The table looks like this :
CREATE MULTISET TABLE DEVG123AHE.EXCHANGEGROUP ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( EGP_ID CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, EGP_START_DT DATE FORMAT 'yyyy-mm-dd' NOT NULL, EGP_END_DT DATE FORMAT 'yyyy-mm-dd' NOT NULL, CUY_ID_BASE CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, EGP_UPDT_TD TIMESTAMP(0) NOT NULL, EGP_UPDT_USER_ID CHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) UNIQUE PRIMARY INDEX EXCHANGEGROUP_UPI ( EGP_ID ,EGP_START_DT ); 'Wrong number of data values in Import file'
I thought it was to do with TimeStamp(0) formats but I can't seem to get even the simplest import to work for some reason.
Can anyone get this very simple import to work ? What very silly thing am I doing wrong ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|