Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 04 Aug 2002 @ 00:38:42 GMT


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


Subj:   Re: Fast export and Varchar
 
From:   Rohit Revo

You know Teradata, to save space, groups all the varchar fields together in a row at one place and for each varchar field it allocates an additional 2 bytes which contain the address of the start of the varchar field. This is an overhead but saves a lot of space. You will find this 2 bytes for each varchar field.

YOu will get it if you are using the mode INDICATOR. If you just want to load the data in some Teradata table, just go ahead and use MLOAD of FastLoad. Teradata utilities recognise these 2 bytes internally. But if you are using this for some report generation then use the MODE RECORD but you will have to cast each field as character based on the filed length which you will find in Queryman in show definition.

ROHIT REVO



     
  <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