Archives of the TeradataForum

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

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

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