Shell Programming and Scripting

here we go..

While loop is not working file.. It also invokes one more shell scripts for which parameters need to passed on.

Code:

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}

INPUT_FILE

Code:

 
ksh invoke.ksh <parameter1> <parameter2>

Moderator's Comments:

Use code tags please, ty.

Then maybe build in a counter ie. a variable that is set in the start to 1 and at the end of the loop (still inside) is incremented by 1, using the shell's arithmetic functions or let or expr. Use this variable in the filename when redirecting output so you have different names for each load counting up.

Code:

ksh invoke.ksh <parameter1> <parameter2>

The ksh is not needed in front of the line. Remove it and use a sheband which means 1st line in your script has to be

Code:

#!/usr/bin/ksh

<parameter1> will be $1 inside your script and <parameter2> will be $2. So when calling the second shell script, just pass those 2 positional shell parameters to the script when calling it like:

Code:

secondscript.ksh $1 $2

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 &

I see none of the suggestions I made built into your script and you also ignored my bid to use code tags which you also got as PM with explanation how to use them.
What did you not understand what I wrote?

I am trying to build a script which will around 10-15 main scripts one after another.

Basically two parameters are passed when running the shell script $1 & $2.

Also main shell script various for every 4 commands.

Suppose
ksh tbl.ksh $1 $2
ksh vw.ksh $1 $2
ksh mcr.ksh $1 $2

Since you seem to ignore code tag requests and PMs and also give no answer to the suggestions for your problem made, you are collecting infraction points this way. When you have collected 30, you will be banned from the forum. I am not sure if this is your goal but I do not want to deprive this information.