Archives of the TeradataForum

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

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

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>>