Shell Programming and Scripting

Guys,

I've written the following to proces one line at a time and then process individual column within the line.. But it works only when there is one line. I know awk will simply fetch multiple lines when run against a file with many lines. How do i achieve this ?




cat ${PARFILE} | while read line
do
DBID=`awk '{print $1}' $line`
USERID=$(${ORACLE_BASE}/getpass.ksh SYS ${DBID})
echo userid is $USERID
TSNAME=`awk '{print $2}' $line`
echo tablespace is $TSNAME
runSql "${USERID}" "${TSNAME}"
echo $COUNT

THRESHOLD=`awk '{print $3}' $line`
echo Threshold=$THRESHOLD
if [[ $COUNT -lt $THRESHOLD ]]
then
DIFF=`expr $THRESHOLD - $COUNT`
echo "Diff is $DIFF"
MSG="Please add ${DIFF} Mb to tablespace ${TSNAME} on ${DBID}"
echo $MSG >> /tmp/ts_add.out
fi

done






The parfile is

strd1.uk.ml.com STR_DATA 2180
strp2.uk.ml.com STR_INDEXES 900
strp2.uk.ml.com STR_LOB_DATA 500
ukpp1.uk.ml.com SAMBA_DAT 800


Thank you

All that i am trying to do is display individual column values for each line and something with it

10.2.0> cat .TS_DETAILS | while read line
> do
> echo $line
> echo `awk '{print $1}' ${line}`
> done
strd1.uk.ml.com STR_DATA 2180
awk: cmd. line:2: fatal: cannot open file `strd1.uk.ml.com' for reading (No such file or directory)

strp2.uk.ml.com STR_INDEXES 900
awk: cmd. line:2: fatal: cannot open file `strp2.uk.ml.com' for reading (No such file or directory)

strp2.uk.ml.com STR_LOB_DATA 500
awk: cmd. line:2: fatal: cannot open file `strp2.uk.ml.com' for reading (No such file or directory)

ukpp1.uk.ml.com SAMBA_DAT 800
awk: cmd. line:2: fatal: cannot open file `ukpp1.uk.ml.com' for reading (No such file or directory)

Use as.

Code:

echo $line | awk '{...}'

shamrock.. Many thanks for your help.. Much appreciated