Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Fastexport HEX chars at the beginning of each record
From:   Anomy Anom

<-- 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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020