Hi,
I have two files to pick and excute these ones.
File1
OLFIN.PRL_100.OIB.TLU.001.D20110510.T144948
File2
OLFIN.PRM_100.OTU.001.D20100726.T050026
date '+%H:%M:%S'
SCRIPTS_PATH=/u/dolfin/bin
. ${SCRIPTS_PATH}/set_dolfin_env.sh
DATA_FILE_NAME=DATA_FILE
DATE_FORMAT=`date '+%Y%m%d'`
DATE_FORMAT=20110323
cd ${DOLFIN_IN_DIR}
# Try to get a data file matching the pattern and check if the data file exists or not
SAP_DATA_FILE=`ls DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU|OTU'`
if [ ! -z "${SAP_DATA_FILE}" ]
then
echo "Found SAP data file ${SAP_DATA_FILE}"
cd ${DOLFIN_BIN_DIR}
i=0
for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU'
do
let i=i+1
SQL Load all the sap data from SAP_TUR into data management tables
sqlldr ${ORA_USER}/${ORA_PASSWD} control= /u/dolfin/bin/load_sap_credit_template.ctl bad=/u/dolfin/log/ data=$file
#move the processed data file to in_arc directory
mv $file ../in_arc
# Compress the data file
compress ../in_arc/$file
# echo $file archived
echo "Finished loading SAP data from TURKEY"
done
else
echo "No SAP data found for TURKEY!!!"
fi
date '+%H:%M:%S'
But getting error as
"load_sap_credit_data_oib_turkeynew1.sh[29]: syntax error at line 35 : `|' unexpected"
Reason is in the code
" for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU' "
This is invalid.
Could you please let us know replacing correct stmt in place of above code.
Appricate early response on this