Select Count(*) From ClearTransferData	Where AccountNo = '25010002'
and  TransferFlag = 'TRI' and TransferType = 'NCT'
and RejectType = 'C' and AdpNumber = '       ' and
 Shares = '0.00000' and ProcessingDate = '2003-05-15 00:00:00.000'

my $sql="Select Count(*) From ClearTransferData
Where AccountNo = '$data[0]' and  TransferFlag = '$data[1]' and
TransferType = '$data[2]' and RejectType = '$data[3]' and
AdpNumber = '$data[4]' and Shares = '$data[5]' and ProcessingDate = '$data[6]' ";

$result = $dbh->do($sql);
 my $ncount = $result;
 print "$sql\n";
print "$ncount\n";