script_temp.sh

#!/bin/bash
filePath=$1
dos2unix $filePath

OR_CON2=pre_dev/'newdev'@192.168.2.4/payprodb
echo "load data infile $filePath append into table T_UM_USER_IDENTITY_TEMP fields terminated by \",\" OPTIONALLY ENCLOSED BY \" ' \"  TRAILING NULLCOLS (USER_TYPE,USER_SUB_TYPE,USER_SEGMENT,REGION_CODE,PARENT_ID,MSISDN,ALTERNATE_PHONE_NUMBER,EMAIL,ALTERNATE_EMAIL,DOB,FIRST_NAME,MIDDLE_NAME,LAST_NAME,FATHER_NAME,GENDER,ADDRESS,LANGUAGE,MOBILE_OPERATOR,WORK_ID,WORK_NAME,COUNTRY_ID,BANK_NAME,BENEFICIARY_NAME,NICK_NAME,BENEFICIARY_ACCOUNT,BENEFICIARY_TYPE,BIN,MOTHER_NAME,IDENTITY_TYPE,IDENTITY_ID,BUSINESSTYPE,WNI,WNA,NPWP_SIUP,BANK_NAME_SETTLEMENT,NICK_NAME_SETTLEMENT,BENEFICIARY_ACCOUNT_SETTLEMENT,BENEFICIARY_TYPE_SETTLEMENT,BIN_SETTLEMENT,MDR,PROMOTION,SETTLEMENT,COLLABORATION)" >U.ctl
sqlldr ${OR_CON2} ROWS=5000 bindsize=104857600 log=U.log  control=U.ctl skip=1