why the below script is not working .,

Can any one please help me out.,

for prevfile in $temp; do
prevfile=$prevfile.`date +%D%H%M%S`
mv $prevfile ../../commitments/olddata
done


Raja

What's the purpose of the for loop? Is $temp a wildcard or something?

How is it not working?

that's because you did not create the new file first before mv'ing to destination.

My actual Script is :

#!/bin/ksh
################################################################################
INPARM=$1
. /sharedapps/etlusr/etlusrenv/etlusrenv repcommitments
#To remove the old log files
if [ "$INPARM" = staging ]; then
FTPLOGIN=$STGFTPLOGIN
FTPPASSWD=$STGFTPPASSWD
SERVERNAME=$STGSERVERNAME
FILEPREFIX=ORDPT.
ORAUSER=ecometlusr/ecometlusr_dev@ecomd

elif [ "$INPARM" = qa ]; then
FTPLOGIN=$QAFTPLOGIN
FTPPASSWD=$QAFTPPASSWD
SERVERNAME=$QASERVERNAME
FILEPREFIX=ORDPT.
elif [ "$INPARM" = production ]; then
FTPLOGIN=$PRODFTPLOGIN
FTPPASSWD=$PRODFTPPASSWD
SERVERNAME=$PRODSERVERNAME
FILEPREFIX=ORDPP.
else
echo "NOTE: $INPARM is not a valid running environment"
echo "Usage: gasbuster_incentive_extract.ksh <staging/qa/production>"
exit 1
fi
cd $LOGPATH
rm rep_commitment_load*
OUTPUTLOGFILE=$LOGPATH/rep_commitment_load.log;export OUTPUTLOGFILE;
cd /sharedapps/etlusr/etl/ftp/
temp=`ls ORD*`
for prevfile in $temp; do
prevfile=$prevfile.`date +%D%H%M%S`
mv $prevfile $OLDDATAPATH
done

#$prevfile=`find /sharedapps/etlusr/etl/ftp/ORD*`
echo $prevfile >>$OUTPUTLOGFILE
#mv `find /sharedapps/etlusr/etl/ftp/ORD*` $OLDDATAPATH/`find /sharedapps/etlusr/etl/ftp/ORD*`.`date +%D%H%M%S`
#echo "open $SERVERNAME">$LOGPATH/rep_commitment_load
echo "user $FTPLOGIN $FTPPASSWD">>$LOGPATH/rep_commitment_load
echo "quote site blocksize=8000 lrecl=80 recfm=fb">>$LOGPATH/rep_commitment_load
echo "cd ..">>$LOGPATH/rep_commitment_load
echo "lcd $LOGPATH">>$LOGPATH/rep_commitment_load
sqlplus -s $ORAUSER <<EOF >OUTPUTLOGFILE
@$SCRIPTDIR/rep_commitment_load.sql
EOF
echo "mput ORD* >>$LOGPATH/rep_commitment_load_ftp
echo "close">>$LOGPATH/rep_commitment_load_ftp
echo "quit">>$LOGPATH/rep_commitment_load_ftp
echo "Done FTP commands"

ORAERRCNT=`cat rep_commitment_load* | grep "ORA-"|wc -l`
ONECNT=1
if [ $ORAERRCNT -lt $ONECNT ]; then
ftp -ivn < $LOGPATH/rep_commitment_load_ftp >$LOGPATH/rep_commitment_load_ftp.log

================================================================
Rep Commitment Load process successfull.
Please check log file - $OUTPUTLOGFILE
================================================================="
exit 0
else
cat $DATEFILEPATH >> $OUTPUTLOGFILE
echo "
================================================================
Rep Commitment Load process failed with ORA errors.
Please check log file - $OUTPUTLOGFILE
================================================================="
exit 1
fi
exit 0
fi
exit;
##############################################################################


I am able to call the sql file., but the files not getting moved to OLDDATAPATH ., from the for loop.,

Please look after and help me out.

Raja

So what do you get if you run a pared-down version like this one?

Error messages? Incorrect output? Magically wake up in Tahiti and none of this seems like much of a problem any longer?

Never mind that, you are not defining OLDDATAPATH anywhere so it cannot work

The OLDDATAPATH is an environmental variable ., the path will be referred from the env file .,

Raja