Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files
I've promoted about 2X speed by named pipe.

First step:(create a named pipe)

mkfifo p1


Second step:(waiting to convert)

cat p1| iconv -f GBK -t UTF-8 &gt; target.file


Last step:(export to p1, see the sql scripts below)

SET OPTION TEMP_EXTRACT_NAME1 = 'p1';
SELECT * FROM MY_TABLE;
SET OPTION TEMP_EXTRACT_NAME1 = '';