netezza nzload 加载 编码转换

rm -p /tmp/${tabname}.fifo
mkfifo -m 666 /tmp/${tabname}.fifo

cat ${filename} | nzconvert -f gbk > /tmp/${tabname}.fifo &
nzload -db sdata_dev -u etldev -pw etldev -host 10.10.50.241 -t WEB_ORDER_LOG_20120504 -maxErrors 1000 -delim ',' -df /tmp/${tabname}.fifo -encoding utf8 &

wait

转载于:https://blog.51cto.com/jackwxh/871208