Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Jan 2012 @ 17:23:32 GMT


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


Subj:   Re: Missing a setting here ..can't recollect what
 
From:   Geoffrey Rommel

BTEQ by default uses Field Mode, which means that it retrieves the result set one column at a time. This is slow, but the advantage is that each column is formatted for you by the database -- either the default format for the data type or the format specified in the Create Table statement.

SQL Assistant, and most other applications, use Record Mode. This means that the columns are ordinarily returned in internal form; e.g., integers are 32-bit binary, varchars have a 16-bit integer on the front, and so on.

Formatting has to be done by the application, unless you override the format for individual columns by saying something like "cast(cast( time_col as format '99:99:99') as char(8))".



     
  <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