Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Jun 2014 @ 15:58:22 GMT


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


Subj:   Re: How to get complete SQL by Combining DBQLSQLTBL and DBQLOGTBL
 
From:   Geoffrey Rommel

After creating the table, run SHOW TABLE on it. If you created the table from an ODBC session, you will probably find that Col3 is not defined as TIMESTAMP(6) but as something else.

To fix this problem, edit your ODBC data source to use option 'AAA' for the Date/Time/Timestamp types or, better yet, connect with Teradata.Net rather than ODBC.



     
  <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: 15 Jun 2023