Archives of the TeradataForum

Message Posted: Thu, 06 Nov 2008 @ 16:22:51 GMT

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

<-- Anonymously Posted: Thu, 6 Nov 2008 11:19 -->

Is there any way to NOT get the HEX characters at the beginning of a Fastexport records. I can do this in BTEQ, but would like to do this via Fastexport. I have one big char string that I am exporting

     SELECT COLA||'|'||COLB||'|'||COLC...

I have tried multiple format/mode combinations, but always seem to get these characters at the beginning. Here is one example of what I get...

The 340023868 in the first row is the beginning of the 1st record, but I am getting hex chars added to the beginning. I have checked the manual, but the fastexport manual does not appear as detailed as some of the other utility manuals from an example perspective. If anyone has an example, that would be GREAT!!!

     @ 340023868|354|08/10/25|34006|1|5.00|2.500|.00|.0000|20.00|4.0000
     B 160019916|4449|08/10/25|16003|4|5.00|1.550|.00|.0000|80.00|16.0000
     E 612003213|4045|08/10/25|61201|3|199.99|90.110|.00|.0000|799.96|4.0000

Thanks in advance!

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