#************************************************************************#
#*************** CHECKING THE BCP STATUS ********************************#
# this  writes the output from the bcp in  into the  OUTPUT.out file #
#************************************************************************#
echo
echo '*** NEXT LINES ARE OUTPUT FROM  BCP IN PROGV TABLE***'
cat bcpinprovmsg.out
echo
# this checks for bcp in  failure message
bcpinprov=`grep -i "bcp copy in failed" bcpinprovmsg.out`
if [ "$bcpinprov" = "" ]; then
   echo "BCP COPY IN PROGV SUCCEEDED"
   # this routine returns the number of rows in GV
   # and assigns it to  rcInP variable     
   rowsInProv=`grep -h "Number of rows in PROGV" $RUNDIR/OUTPUT.out` 
      count=1
      for i in $rowsInProv
      do
        if  [ $count -eq 6 ]; then
          rcInP=$i   
        fi
        count=`expr $count + 1`
      done
      
   rowsInProvAudit=0
   rowsInProvAudit=`grep -h "Number of records written for  PROGV
bcp:" $MMISDIR/Provider_Audit.log` 
   echo $rowsInProvAudit
          countP=1
        for i in $rowsInProvAudit
        do
         if [ $countP -eq 8 ]; then
          rcInPAudit=$i
         fi
         countP=`expr $countP + 1` 
        done
              
   echo "Number of Records in  ProGV file = " $rcInPAudit  
   echo "Number of Rows Copied into PROGV= " $rcInP    
   
         
  if [ "$rcInPAudit" = "$rcInP" ]; then
         echo 'correct number of rows were loaded into PROVIDER'  
  else                                                                
       echo '*** WARNING *** WARNING *** WARNING *** WARNING ***'         
       echo '  Discrepancy between number of records in PROGV.txt ' 
       echo '  and number of rows loaded into PROGV. Check bcp'
       echo '  load statistics and ProvLoadInErr.out file.'
       echo
       if [ -r ProvLoadInErr.out ]; then
          echo '*** REJECTED ROWS FROM BCP OF PROGV.txt ***'
          cat ProvLoadInErr.out
       fi
           SUBJECT=""$runat"-ProGV_Processing_OfRows:Error"
           mailx -s $SUBJECT $MAILTOPROG < $RUNDIR/OUTPUT.out
           exit
  fi
else
     SUBJECT=""$runat"-ProGV_Processing_OfRows:Error"
     mailx -s $SUBJECT $MAILTOPROG < $RUNDIR/OUTPUT.out
     exit
fi
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

if [ ! "$bcpinprov" ]; then

if  [ "$count" -eq 6 ]; then

 if [ "$countP" -eq 8 ]; then

A binary comparison operator compares two variables or quantities. Note that integer and string comparison
use a different set of operators.
integer comparison
-eq
is equal to
if [ "$a" -eq "$b" ]
-ne
is not equal to
if [ "$a" -ne "$b" ]
-gt
is greater than
if [ "$a" -gt "$b" ]
-ge
is greater than or equal to
if [ "$a" -ge "$b" ]
-lt
is less than
if [ "$a" -lt "$b" ]
-le
is less than or equal to
if [ "$a" -le "$b" ]

<
is less than (within double parentheses)
(("$a" < "$b"))
<=
is less than or equal to (within double parentheses)
(("$a" <= "$b"))
>
is greater than (within double parentheses)
(("$a" > "$b"))
>=
is greater than or equal to (within double parentheses)
(("$a" >= "$b"))
string comparison
=
is equal to
if [ "$a" = "$b" ]
==
is equal to
if [ "$a" == "$b" ]

!=
is not equal to
if [ "$a" != "$b" ]
This operator uses pattern matching within a [[ ... ]] construct.
<
is less than, in ASCII alphabetical order
if [[ "$a" < "$b" ]]

if [ "$a" \< "$b" ]
Note that the "<" needs to be escaped within a [ ] construct.
>
is greater than, in ASCII alphabetical order
if [[ "$a" > "$b" ]]
if [ "$a" \> "$b" ]
Note that the ">" needs to be escaped within a [ ] construct.


in conclusion (using bash or ksh shells) :-
you are testing 2 numerical variables (numbers) you have to use the first kind of operators (-eq) not the string operator
you can use the string operator in double parentheses ( [[..]] )

so use [[ "$rcInPAudit" = "$rcInP" ]] or [ "$rcInPAudit" -eq "$rcInP" ] to eliminate the error.

BR