Archives of the TeradataForum

Message Posted: Thu, 26 Apr 2007 @ 20:27:33 GMT

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

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.

Good Luck.

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