[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DECmcc user notes file. Does not replace IPMT. |
| Notice: | Use IPMT for problems. Newsletter location in note 6187 |
| Moderator: | TAEC::BEROUD |
|
| Created: | Mon Aug 21 1989 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 6497 |
| Total number of notes: | 27359 |
5429.0. "Purging exported data...........?" by KERNEL::DAVIES () Wed Aug 04 1993 09:41
Hi,
I have a simple question regarding the purging of exported data.
With the historian you can specify a keep age for collected data
and it will be automatically purged for you. If, however, you
are exporting to an RDB file, either on-line or from the MIR, how
do you purge data then?
Are there specific RDB tools to do this??
Any help greatly appreciated.
Phil Davies. UK Comms TSC.
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 5429.1 | We do this | GLDOA::KATZ | Follow your conscience | Wed Aug 04 1993 10:14 | 6 |
| You could try
$ define sql$database dka...[blahblah]blah
$ mc sql$
set transaction read write;
delete FROM MCC_SNMP_INTERFACE WHERE TIME_STAMP < '23-JUL-1993' ;
|
| 5429.2 | Ta............... | KERNEL::DAVIES | | Tue Sep 07 1993 07:57 | 7 |
| Hi,
Belated thanks for your reply..........
Cheers,
Phil.
|