example shell to excute sqlldr

#!/bin/ksh

#Define variable

V_NUM_COUNTER=0

 

#Exitif thereisno parameter passed.

if[$#=0]

then

    echo "========================================="

    echo "No parms were passed to the Shell Program"

    echo "========================================="

    exit1

fi

 

#Get the parametervalue

while["$V_NUM_COUNTER"-le$#]

do

    echo "============================="

    echo "Show passed parameter $V_NUM_COUNTER : "

    echo "============================="

    case"$V_NUM_COUNTER"in

        0) echo"$0";;

        1) echo"$1"

                V_CHR_DB_CONN="$1";;

        2) echo"$2";;

        3) echo"$3";;

        4) echo"$4";;    

        5) echo"$5"

            V_CHR_CTL_FILE="$5";;

        6) echo"$6"

            V_CHR_DATA_FILE="$6";;

        *) echo" Not parm 0 thru 8";;

    esac

    V_NUM_COUNTER=`expr$V_NUM_COUNTER+1`

done

 

######Print file information######

echo "=============================="

echo "Control file = $V_CHR_CTL_FILE"

echo "Data file = $V_CHR_DATA_FILE"

echo "=============================="

######Parameter validation######

 

if[!-f$V_CHR_CTL_FILE]

then

  echo "========================================="

  echo "Control file: $V_CHR_CTL_FILE is invalid!"

  echo "========================================="

  exit1

fi

 

if[!-f$V_CHR_DATA_FILE]

then

  echo "======================================="

  echo "Data file: $V_CHR_DATA_FILE is invalid!"

  echo "======================================="

  exit1

fi

 

######Start sqlldr######

echo "======================="

echo "Start to load data....."

echo "======================="

sqlldr userid=$V_CHR_DB_CONN control=$V_CHR_CTL_FILEdata=$V_CHR_DATA_FILE

 

if[$?-eq0]

then

  echo "=========================="

  echo "Loading Data Successfully!"

  echo "=========================="

  exit0

else

  echo "============================================"

  echo "Loading data failed. Please check log file!"

  echo "============================================"

  exit1

fi