Script to upload the valid file database

#!/bin/bash

#Purpose:upload custdata file to sales table
#version:1.0

v=('/data' 'cust.csv' 'sales' 'cust.ctl')
v1="hr"
v2="12345"

while true
do

cd ${v[0]} 

test -f ${v[1]}

    if [ $? -eq 0 ]
    then
	if [ -s ${v[1]} ]
	then
	    sqlldr $v/$v1 control=${cred[3]} 
		if [ $? -eq 0 ]
		then

		    mail -s "update success" dbteam@cts.com </tmp/body1
		else
		    mail -s "update fail" dbteam@cts.com </tmp/body2
		fi

	else 
		
		mail -s "cust file empty" dbteam@cts.com </tmp/body3
	fi
	
sleep 5	

fi

done



control file
============


vi cust.ctl

load data infile "/data/cust.csv"
append
into table sales
fields terminated by " " 
(cust_name cust_id salary)