Shell Programming and Scripting

#!/bin/ksh
. /home/application/bin/application.env
OUTFILE=Result.txt
PROD_PASSWORD=`${GET_PWD} -f ${PWD_FILE_PATH} -s ${PROD_SERVER} -u ${PROD_USER}`
echo "1)To get the book last loaded details "
read value
if [ $value -eq 1 ]
then
count=`cat input.txt | wc -l`
 
while [ $count -eq 1 ]
do
bookname=`cat input.txt | tail -$count |head -1`
/sbcimp/run/tp/sybase/prod/bin/isql -U${PROD_USER} -D${PROD_DB} -P${PROD_PASSWORD} -S${PROD_SERVER} -o$OUTFILE <<EOF
select p.period ,b.book from period p ,book b where p.id in( select b.id_period_cob from book where b.book in("$bookname"))
go
EOF
count=`expr $count - 1`
done

fi

/bin/ksh -x YOUR_SCRIPT

bookname=`sed -n "$count  p"  input.txt`

while [ $count != 0 ]
do
bookname=`cat input.txt | tail -$count |head -1`
/sbcimp/run/tp/sybase/prod/bin/isql -U${PROD_USER} -D${PROD_DB} -P${PROD_PASSWORD} -S${PROD_SERVER} -o$OUTFILE <<EOF
select p.period ,b.book from period p ,book b where p.id in( select b.id_period_cob from book where b.book in("$bookname"))
go
EOF
count=`expr $count - 1`
done

        while read LINE
        do
            echo "$LINE"
        done < $FILENAME

OUTFILE=Result.txt
while read LINE
do
/sbcimp/run/tp/sybase/prod/bin/isql -U${PROD_USER} -D${PROD_DB} -P${PROD_PASSWORD} -S${PROD_SERVER} -o$OUTFILE <<EOF
select p.period ,b.book  from period p ,book b  where p.id in( select b.id_period_cob from book where b.book in("$LINE"))
go
EOF
done <input.txt