Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 May 2009 @ 09:32:00 GMT


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


Subj:   Table Created via FastLoad v/s SQL ASSISTANT
 
From:   Chaithanya R Abbaraju

Hi All

I have created table via FastLoad and SQLASSISTANT the DataType created with TIME(0) for the Columns as below

     CREATE SET TABLE DATABASENAME.TABLENAME ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
     (
           source_system_code SMALLINT NOT NULL,
           ohduedate_time TIME(0),
           ohrefdate_time TIME(0),
           ohentdate_time TIME(0),
     )
     UNIQUE PRIMARY INDEX ( source_system_code)

FastLoad the datatype is showing as

     Column Name                Type
     ohduedate_time             AT
     ohrefdate_time             AT
     ohentdate_time             AT

And when I create via SQL Assistant its showing as

     Column Name                Type
     ohduedate_time             I
     ohrefdate_time             I
     ohentdate_time             I

Can any one help me out?


Thanks and Regards

Rahul Abbaraju



     
  <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