Archives of the TeradataForum
Message Posted: Thu, 22 Jul 2010 @ 18:03:38 GMT
| 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
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;