Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   SQL Assistant Import
 
From:   David Clough

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016