DB2装数shell脚本

#!/bin/bash
#export LANG=zh_CN
#export NLS_LANG=zh_CN.UTF-8
export NLS_LANG=AMERICAN.AL32UTF8

##########################主程序##########################
#程序使用方法提示
if [ $# -ne 4 ]
then
    echo "Usage:`basename $0` YYYYMMDD TABLE_NAME FILE_NAME SYS_NAME"
    exit 1
fi

#变量声明
dbUser=yusp
dbPassword=yusp
dbName=YUSP

ETL_DATE=$1
TABLE_NAME=$2
FILE_NAME=$3_${ETL_DATE}.dat
FLAG_NAME=$3_${ETL_DATE}.flg
SYS_ID=$4
DATA_DIR=/impdata/${SYS_ID}/${ETL_DATE}

if [ -e ${DATA_DIR}/$FILE_NAME ]
then
    echo "data file is ready"
else
    echo "data file dose not exit"
    #数据文件不存在则报错退出
    exit -1
fi

#数据装载
echo "db2 client import from ${DATA_DIR}/$FILE_NAME of del modified by coldel0x01 commitcount 100000 insert into $TABLE_NAME"
db2 connect to ${dbName} user ${dbUser} using ${dbPassword};
db2 "load client from ${DATA_DIR}/$FILE_NAME of del modified by timestampformat=\"YYYYMMDDHHMMSS\" dateformat=\"YYYY-MM-DD\" codepage=1383 coldel0x01 nochardel replace into $TABLE_NAME nonrecoverable"