 |
 |
Archives of the TeradataForum
Message Posted: Thu, 06 Nov 2008 @ 17:22:31 GMT
| Subj: | | Re: Fastexport HEX chars at the beginning of each record |
| |
| From: | | Dempsey, Mike |
The 2 character prefix is actually the (binary) length of the string. The only way I know to avoid it is to cast the string to a fixed length.
That should work (but with trailing blanks on each value) if these strings will always be within a fairly narrow range of lengths.
Eg.
SELECT COLA||'|'||COLB||'|'||COLC (CHAR(80)) ...
Mike Dempsey
Teradata Client Tools
| |
