Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Jul 2010 @ 18:03:38 GMT

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

Subj:   Re: OutMod for FastExport
From:   Bob Hahn

bteq export data outputs format 'fastload' also sometimes called format 'formatted'--2 byte length preceding that many bytes with a record separator x0a.

bteq export report outputs character without the length field--it uses Teradata field mode where Teradata converts and returns the data in character format. It is slower than record mode bteq and fastexport, but for smaller amounts of data is fine.

Here's a bteq that can output vartext without having to cast and without the length field and with field delimiters too--a useful trick to get vartext output. The tpt dc when used with the sql selector operator can do the same.

     .set session respbuflen max1mb;
     .set titledashes off;
     .set separator ',';
     .set width 65531;
     .set retlimit 1000,2048;
     .export report file=reportfile;
     select whatever.

  <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: 23 Jun 2019