loadIncrementalData.sh

OR_CON2=umarketadm/spice#123@192.168.2.5/utiba
#OR_CON2=paypro/spice#123@192.168.2.5/live
#echo "load data  infile '${1}' APPEND into table INC_ACCOUNT fields terminated by \",\" TRAILING NULLCOLS (ID,TYPE_,AGENT,AGENT_TYPE,CREATED,OPEN_DATE,OPEN_BALANCE,CURR_BALANCE,AVAIL_BALANCE,PEND_BALANCE,THRESHOLD,RATE,STATUS,LIMIT,UPPER_LIMIT,CSID,ACCOUNT_PRODUCT_ID,ACCOUNT_PRODUCT_EFFECTIVE,MIN_BALANCE,MIN_CLOSE_BALANCE,SUM_CLOSE_BALANCE,CLOSE_BALANCE_EFFECTIVE,INTEREST_ACCRUED,INTEREST_ACCRUAL_EFFECTIVE,INTEREST_POST_EFFECTIVE)" >U.ctl
#echo "load data  infile '${1}' APPEND into table INC_AGENT_BODY fields terminated by \",\" OPTIONALLY ENCLOSED BY \"'\" TRAILING NULLCOLS (ID,SALT,CREATED_DATE,NAME,EMAIL_ADDRESS,SMS_ADDRESS,LANGUAGE,STATUS,AGENT_TYPE,ORGANISATION,DS_COMMISSION,POS_COMMISSION,AGENT_OBJECT,REG_TXN,LO_BAL_THRES,LO_BAL_AMOUNT,LO_BAL_SOURCE,HI_BAL_THRES,HI_BAL_AMOUNT,HI_BAL_SOURCE,LAST_AUTO_CASH,OWNER_AGENT,AGENT_CATEGORY,DATA_1,DATA_2,DATA_3,DATA_4,DATA_5,DATA_6,DATA_7,DATA_8,DATA_9,DATA_10,DATA_11,DATA_12,DATA_13,DATA_14,DATA_15,DATA_16,DATA_17,DATA_18,DATA_19,DATA_20)" >U.ctl
#echo "load data  infile '${1}' APPEND into table INC_AGENT_BODY fields terminated by \",\" TRAILING NULLCOLS (ID,SALT,CREATED_DATE,NAME,EMAIL_ADDRESS,SMS_ADDRESS,LANGUAGE,STATUS,AGENT_TYPE,ORGANISATION,DS_COMMISSION,POS_COMMISSION,AGENT_OBJECT,REG_TXN,LO_BAL_THRES,LO_BAL_AMOUNT,LO_BAL_SOURCE,HI_BAL_THRES,HI_BAL_AMOUNT,HI_BAL_SOURCE,LAST_AUTO_CASH,OWNER_AGENT,AGENT_CATEGORY,DATA_1,DATA_2,DATA_3,DATA_4,DATA_5,DATA_6,DATA_7,DATA_8,DATA_9,DATA_10,DATA_11,DATA_12,DATA_13,DATA_14,DATA_15,DATA_16,DATA_17,DATA_18,DATA_19,DATA_20)" >U.ctl
#echo "load data  infile '${1}' APPEND into table INC_AGENT_REF fields terminated by \",\" TRAILING NULLCOLS (ID,REFERENCE,DELETED,CREATED_DATE,DELETED_DATE,BODYID,REF_TYPE)" >U.ctl
echo "load data  infile '${1}' APPEND into table INC_AGENT_DATA fields terminated by \",\" TRAILING NULLCOLS (AGENT_ID,AD_KEY,VALUE)" >U.ctl
#echo "load data  infile '${1}' APPEND into table BAL_SNAPSHOT fields terminated by \",\" TRAILING NULLCOLS (AB_ID,CURR_BALANCE,AVAIL_BALANCE,PEND_BALANCE)" >U.ctl
sqlldr ${OR_CON2} ROWS=500000 bindsize=10485760 log=U.log  control=U.ctl skip=1