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;
     .BEGIN EXPORT
        SESSIONS 4;

     .EXPORT
              OUTFILE test_utf8.out
              FORMAT UNFORMAT
              MODE INDICATOR ;

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

     .END EXPORT;
     .LOGOFF;

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: 15 Jun 2023