Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!uwm.edu!bionet!agate!usenet.ins.cwru.edu!mcs.kent.edu!neoucom.edu!aablue!jb
From: jb@aablue.aablue.com (John B Scalia)
Newsgroups: comp.databases
Subject: Little problem with Unify
Keywords: Unify SCOM
Message-ID: <1991Apr5.004919.9136@aablue.com>
Date: 5 Apr 91 00:49:19 GMT
Sender: clint@aablue.aablue.com (Clint Quah)
Organization: AA Blueprint Co., Inc.
Lines: 20

(Posting this for a colleague, either post here or e-mail
to clint@aablue.com, thanks!):

I ran into a problem two days ago. First, I executed an SQL statement to get
the count of the total records in a specific table and then I ran another one
to get the count of those with valid reference field which is 6 records short
of the total count. So I dumped all the records from this table and ran a 
delete statement in SQL mode to clean up the table. After I did that,
I still got a record count of 6 in this supposedly empty table. I've concluded
that I probably need to run SCOM on it, but I'd prefer a simpler way to
get rid of these 6 bad records without spending another two and a half
hours :).
Any help will be appreciated.

Clint.
--------------
-- 
Respond to:                     |
jb@aablue.com       or          | "Here's my .sig ain't it weird"
uunet!aablue!jb                 |