Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Jun 2006 @ 14:38:08 GMT


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


Subj:   Re: Newlines in BTEQ EXPORT under Unix
 
From:   Geoffrey Rommel

  When I put de DATA modifier, it generates the report in hexadecimal.  


As Michael mentioned, DATA produces raw data in machine-readable form. To be exact, it is not "in hexadecimal". Hex is just a way of expressing exactly which bits are in a file. *Every* file is "in hexadecimal" if you want to express it that way. Take, for instance, the string 'ABC' in ASCII. The actual bits are '010000010100001001000011'; we express this in characters as 'ABC' or in hex as '414243'xc. The integer 5 in a REPORT file will appear as the character '5' (in hex, '35'xc), but a small integer 5 in a DATA file will appear as x'0005' (or x'0500' in little- endian).

Those who are unclear on these concepts may find the Unix utility 'od' (octal dump) helpful.



     
  <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