Here is the example which is used
Please help me if I am missing out any.
INPUT file has similar to this...
Main script
Script=`basename $0`
IDWADMINMAIL="
xxx@xx.com.au";
WDIR=/home/refresh
LogDir=${WDIR}/log
INPUT_FILE=${WDIR}/all.ksh
ProFILE=${WDIR}/process.log
cd ${WDIR}
while read line
do
####
#### We want to have a logfile for each load
####
PLog="${LogDir}/${Script}.log";
####
#### Need to keep creating DDL one after another
####
echo "${line}" >> ${ProFILE}
${line} >> ${PLog}
done < ${INPUT_FILE}
mailx -s "COMPLETED - DDL Transfer at `date '+%Y%m%d.%H%M'`" ${IDWADMINMAIL} << !!EOT
INPUT_FILE
Sub Script
ksh create_table_project_fromprod2dr.ksh $1 $2 > ItoFtbl.log 2>&1 &
ksh create_table_project_fromprod2dr.ksh $1 $2 > StoFtbl.log 2>&1 &
ksh create_table_project_fromprod2dr.ksh $1 $2 > BtoFtbl.log 2>&1 &
ksh create_table_project_fromprod2dr.ksh $1 $2 > TtoFtbl.log 2>&1 &