Archives of the TeradataForum
Message Posted: Thu, 26 Apr 2007 @ 20:27:33 GMT
| Subj: || || Re: SQL Assistant - Export Results |
| From: || || Rob Paller |
Try casting your fields to VARCHAR in a derived table then:
SELECT || '|' || || '|'|| ...
FROM derived table;
Keep in mind the report width limitations in BTEQ. You may need to use FastExport and then strip the leading two bytes of binary data from the
resulting file in either an OUTMOD or external process. I know UNIX provides a few built in mechanisms to facilitate such processing.