Archives of the TeradataForum

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

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

<-- 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>>