Emergency UNIX and Linux Support

ret=`
EOF`

1LK81JVDE2HRNDG              3               0                                                                         
                                                                                                                       
                                                              
1LMXTJJD0W28TX2              3               0                                                                         
                                                                                                                       
                                                              
1LS1XJGDEVWAC5T              7               1

DBMS_OUTPUT.PUT_LINE('Updated ' || SQL%ROWCOUNT || ' rows:');

1LK81JVDE2HRNDG
3
0
ModifyUsgAuditGroupTable.ksh[74]: secadmin/vivadmin@ltd121a:  not found
1LMXTJJD0W28TX2
3
0
ModifyUsgAuditGroupTable.ksh[74]: secadmin/vivadmin@ltd121a:  not found
1LS1XJGDEVWAC5T
7
1
ModifyUsgAuditGroupTable.ksh[74]: secadmin/vivadmin@ltd121a:  not found

nawk '{{print $1,$2,$3}}'  ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt | while read a b c
do
echo $a
echo $b 
echo $c
ret=sqlplus $db_user/$db_pwd@$db_sid  $a $b $c <<EOF
SET HEADING OFF
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE
CNT  NUMBER(5);
DROPCNT NUMBER(5);
ERRORCNT NUMBER(5);
BEGIN
SELECT COUNT(*) INTO CNT FROM USAGE_INTRNL_ERROR WHERE AUDIT_GROUP_ID='&1';

IF ( CNT != &3) THEN
  SELECT INTRL_DROP_QTY,INTRL_ERROR_QTY INTO DROPCNT,ERRORCNT 
     FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_NBR='&1'; 

     DROPCNT :=DROPCNT-CNT;

     UPDATE USAGE_AUDIT_GROUP 
      SET INTRL_DROP_QTY='DROPCNT' ,INTRL_ERROR_QTY='CNT'  
      WHERE  AUDIT_GROUP_NBR='&1' ;
COMMIT;

END IF;
END;
/
EXIT;
EOF
done

sqlplus $db_user/$db_pwd@$db_sid  $a $b $c <<EOF