Shell Programming and Scripting

 
ls $FILEPATH/${FILENAME}*.csv
 
ALLFILES='ls $FILEPATH/${FILENAME}*.csv'

if [ $? -ne 0 ]
then
  echo "\n    No inbound files to process"
  exit 1
fi
## Loop through each file and load to staging table 
for EACHFILE in $ALLFILES
do
TEMP_FILE=${EACHFILE}a
if [ $? -ne 0 ]
then
  echo "\n    Error"
else
  echo "\nCalling Control File"
sqlldr "$FCP_LOGIN" silent=feedback silent=header silent=partitions control=$CONTROLFILE data=$TEMP_FILE

ALLFILES='ls $FILEPATH/${FILENAME}*.csv'

for EACHFILE in $FILEPATH/${FILENAME}*.csv
do
...
done

#!/usr/bin/ksh

FILEPATH=/choose/whatever/you/need
FILENAME=whatevername
FCP_LOGIN=whateverlogin_you_need
CONTROLFILE=whatever_cntrl_you_need

find $FILEPATH -type f -name "${FILENAME}*.csv" | while read a
do
sqlldr "$FCP_LOGIN" silent=feedback silent=header silent=partitions control=$CONTROLFILE data=$a
done