Sybase数据导出(option)
SET TEMPORY OPTION Temp_Extract_Column_Delimiter='|'
SET TEMPORY OPTION Temp_Extract_Null_As_Empty ='ON'
SET TEMPORY OPTION Temp_Extract_Quotes='OFF'
SET TEMPORY OPTION Temp_Extract_Name1='/home/data/XXX.del'
SET TEMPORY OPTION Temp_ExtraCT_Size1=1073741824
select * from DBPRD.XXX;
SET TEMPORY OPTION Temp_Extract_Name1='';
COMMIT;
Linux (CP936->UTF-8)
db2 connect to dbname
for table in `ls *.del` | awk -F '{print $1}'
do
echo $table
iconv -f gbk -t utf-8 $table.del -o $table.txt
db2 "commit"
db2 "load from $table.txt of del modified by codepage=1208 coldel| replace into DBPRD.XXX
done