Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 08:55:00 GMT


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


Subj:   Re: Fastexport manual inconsistency
 
From:   Dieter Noeth

John Mansfield wrote:

  Fair comment. I am in fact running the script on windows. Should the manual not make it clear that the file will be fundamentally different depending upon what platform the extract is run? Perhaps going so far as to detail what those differences might be.  


ACK.

At least in "Attributes of the Destination File" of the EXPORT command it says:

"The Teradata Database data types in the VM and MVS environments are described in Table 3-3 on page 3-22."


  Perhaps today I will spend the day trying to infer how dec(18,2) fields might actually be packed.  


It's a 8 byte integer with a sclae factor of 100, i.e. 12345.67 is stored as 1234567

In "SQL Ref. Data Types and Literals" the external representation of data types is explained.


Dieter



     
  <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