Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Dec 2002 @ 20:34:48 GMT


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


Subj:   Delimited FastExport Question
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, December 04, 2002 14:05 -->

The following FastExport script whose ouput is being used to load a table in SQL Server is proving to be troublesome:

.BEGIN EXPORT SESSIONS 4;
SELECT '|' ||
       TRIM(FIELD1) || '|' ||
       TRIM(FIELD2) || '|' ||
       TRIM(FIELD3) || '|' ||
       TRIM(FIELD4) || '|' ||
       TRIM(FIELD5)
FROM (SELECT FIELD1
            , FIELD2
            , FIELD3
            , FIELD4
            , FIELD5
        FROM TEST.SAMPLETABLE) T1;

.EXPORT
   OUTFILE "C:\TEMP\SAMPLETABLE.DAT"
   FORMAT TEXT;
.END EXPORT;
.LOGOFF;

The problem with the output of this file is the leading two characters that are inserted for each record exported. Occasionally the delimiting character will appear in the first two characters and as a result the load to SQL Server fails. Is there a way to produce a delimited file that can be read by SQL Server without these additional characters?



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016