<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2>John,</FONT></SPAN></DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff size=2>I'm
on a different OS, so I can't give you details, but I'd guess that there's a
system command that you could use to delete all the records in a
table.</FONT></SPAN></DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff size=2>(On
the AS/400, it is CLRPFM.)</FONT></SPAN></DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2>Thanks.</FONT></SPAN></DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=385582719-18082006><FONT face=Tahoma color=#0000ff size=2>David
Morrison</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com
[mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com]<B>On
Behalf Of </B>John Stires<BR><B>Sent:</B> Friday, August 18, 2006 12:20
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Resource
Deadlocks<BR><BR></FONT></DIV>
<DIV>To all,</DIV>
<DIV> </DIV>
<DIV>I am attempting to do maintenance on an archive database. Archive
means VERY LOW usage. Because the indexes were not unique
initially, we have many duplicate records. I am removing these
duplicated records. Once the dupicates are eliminated, we will add a
unique index which should help to prevent this duplicate problem from
happening again. I have saved all the records to a subfile for safe
keeping, just in case.</DIV>
<DIV> </DIV>
<DIV>I am using QTP to delete all of the records in the table and then
load all of the non-duplicate records ack into the table(s).</DIV>
<DIV> </DIV>
<DIV>My problem is that the QTP job is coming up with a "resource deadlock"
error. No one else is attached to the database. I tried
using QDESIGN in creating a very simple QUICK screen to see if I can
bring up a record, which I can, and then delete the one record. Again, I
get the resource deadlock.</DIV>
<DIV> </DIV>
<DIV>Help!!</DIV>
<DIV> </DIV>
<DIV>We are version 7.10.E6, VMS V6.2 and RDB 6.1</DIV>
<DIV> </DIV>
<DIV>Anyone out there have any ideas, wild or otherwise??</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>John Stires</DIV></BLOCKQUOTE></BODY></HTML>