UNIX for Dummies Questions & Answers

conditional is not wworking
can any one figure out what goes wrong

xx1=`$ORACLE_HOME/bin/sqlplus -s apps/ostgapps1 2>/dev/null << EOF
WHENEVER SQLERROR EXIT 1
set head off feedback off ;


WHENEVER SQLERROR EXIT SQL.SQLCODE;
select count(*) from CMS_INVOICE_ALL where AMTEXTN is null;
exit
EOF`

length=`wc -l < $P_FILENAME`


if ${xx1} =${length}
then
echo "Successful completd SQL*Loader "
else
echo "Loading not 100% completed "
PROBLEMS=1
fi

The syntax of if is if command; then ... else ... fi but ${xx1} is not likely to be a valid command. Use the [ aka test command to perform comparisons, or a case structure.

Code:

if [ "$xx1" = "$length" ] ; then
  echo Successfully completed SQL Splat Loader"
fi
# or
case $xx1 in "$length") echo Successfully completed SQL Splat Loader;; esac

use
to get its length