Archives of the TeradataForum

Message Posted: Fri, 05 Aug 2005 @ 11:50:16 GMT

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

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 ?

Thanks
_______________________

Dave Clough
Database Designer
Express ICS

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