Trunc/erasing records from a UD table

Yahoo Archive
1
>> It had something to do with allocation of space.
>> Any thoughts on Truncate vs delete?
I think you are correct about simple deletes - allocations remain.

I don't routinely use truncate, usually just during maintenance:
proutil mfgsys -C truncate bi

This article has some of the highlights:
http://knowledgebase.progress.com/articles/Article/20256




--- In vantage@yahoogroups.com, "cathyattechnologicsys" <cathy@...> wrote:
>
> I worked with Oracle Databases and was told that if you want to empty a table, it was better to use the Truncate rather than the Delete command.
>
> It had something to do with allocation of space.
>
> Any thoughts on Truncate vs delete?
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Squirrel. DELETE from UD01
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > jim_chance
> > Sent: Thursday, August 22, 2013 5:36 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Trunc/erasing records from a UD table
> >
> >
> >
> >
> >
> > Does anyone know how to trunc/erase all records from a UD table for
> > Progress?
> >
> > I have 2 tables that i want to delete all records from. DB is Progress.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
Does anyone know how to trunc/erase all records from a UD table for Progress?

I have 2 tables that i want to delete all records from. DB is Progress.
3
Do you have DMT?


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jim_chance
Sent: Thursday, August 22, 2013 2:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trunc/erasing records from a UD table



Does anyone know how to trunc/erase all records from a UD table for Progress?

I have 2 tables that i want to delete all records from. DB is Progress.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 8718 (20130822) __________


The message was checked by ESET NOD32 Antivirus.


http://www.eset.com


[Non-text portions of this message have been removed]
4
What version are you on?

If you are on 9.05 or higher... do a data directive on the vendor table or on any table....

For last ttvendor no-lock:

For each ud01.

If avail ud01 then do:

Delete ud01.

End.
End.
End.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jim_chance
Sent: Thursday, August 22, 2013 2:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trunc/erasing records from a UD table



Does anyone know how to trunc/erase all records from a UD table for Progress?

I have 2 tables that i want to delete all records from. DB is Progress.



__________ Information from ESET NOD32 Antivirus, version of virus signature database 8718 (20130822) __________


The message was checked by ESET NOD32 Antivirus.


http://www.eset.com


[Non-text portions of this message have been removed]
5
Here is a quick and dirty option I've used with Progress.
Requires MS Access & temporary modification of the ODBC system DSN.

1 - change the ODBC default isolation level from "Read Uncomitted" to blank (this allows full access - so read,write & locks records)

2 - then in Access build a simple delete query on the UD table

Cautions:
- make a backup first
- there is no undo
- change the ODBC isolation level back when you are done



--- In vantage@yahoogroups.com, "jim_chance" <jim_chance@...> wrote:
>
> Does anyone know how to trunc/erase all records from a UD table for Progress?
>
> I have 2 tables that i want to delete all records from. DB is Progress.
>
6
Squirrel. DELETE from UD01





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jim_chance
Sent: Thursday, August 22, 2013 5:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trunc/erasing records from a UD table





Does anyone know how to trunc/erase all records from a UD table for
Progress?

I have 2 tables that i want to delete all records from. DB is Progress.





[Non-text portions of this message have been removed]
7
I worked with Oracle Databases and was told that if you want to empty a table, it was better to use the Truncate rather than the Delete command.

It had something to do with allocation of space.

Any thoughts on Truncate vs delete?

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Squirrel. DELETE from UD01
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jim_chance
> Sent: Thursday, August 22, 2013 5:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Trunc/erasing records from a UD table
>
>
>
>
>
> Does anyone know how to trunc/erase all records from a UD table for
> Progress?
>
> I have 2 tables that i want to delete all records from. DB is Progress.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>