Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2005 @ 01:12:23 GMT


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


Subj:   BTEQ export
 
From:   Michael Larkins

Hi Everyone:

I am teaching a utilities class at a Teradata site and something happened that I have not seen in 10 yrs of working with Teradata. I am at a loss to know why it is happening and therefore wondering if any of you have experienced the same thing.

Situation: when we export DATA a date column from a table into a flat file using a batch script, the date is expanded as YYYY-MM-DD. There is a FORMAT on the column definition in the table, but it is YY/MM/DD. The INTEGER column is binary and the DECIMAL column is packed.

Yet, when I export DATA from the same table using BTEQ interactively, the date is the expected 4-byte binary value.

We were able to Fastload the file, but only after using CHAR(10) in the DEFINE. Just not anything I have ever been required to do previously.

Any ideas or experiences that you care to share which might shed some light on the odd situation would be greatly appreciated.


Respectfully,

Mike



     
  <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