Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 21:19:30 GMT

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

Subj:   Re: FastExport and UTF8 translation of SQL
From:   Anomy Anom

<-- Anonymously Posted: Wed, 27 Feb 2008 16:18 -->

Here is an example.

     $fexp -c utf8 < myscript.txt

     .LOGTABLE utillog;
     .LOGON abc/xxx,yyy;
        SESSIONS 4;

              OUTFILE test_utf8.out
              FORMAT UNFORMAT
              MODE INDICATOR ;

     Select id||','||codepage||','||LCID||','||Description||','||CharData
     from mytable order by 1;


Please note that when you specify a Unicode character as a delimiter, make sure that your script file is saved in UTF8 file encoding. The Fastexport as well as Fastload/Mload do not support the hex representation for the delimiter character.

  <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: 28 Jun 2020