RE: [U2] [UD] Cleaning out _PH_

2008-01-10 Thread David Wolverton
unction we can use there!! Argh!! Or I could just have them buy more disk space... H... Which would actually be easier...) ;-) DW > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee > Sent: Wednesday, January 09, 2008 6:49 PM &

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Bill Haskett
Colin: This is pretty cool. Thanks. :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Wednesday, January 09, 2008 6:17 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] [UD] Cleaning ou

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Jef Lee
David, This will take time to settle to a time where it will function correctly. But here is my suggestion - Day 1 - save a SELECT list of _PH_ using the date of day 1 as part of the key. Day 2-30 - do the same, but remove from list the contents of the previous day's list Day 31 - delete everyt

Re: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Rex Gozar
David, Windows command for finding and deleting files created 120 days ago: cd _PH_ forfiles /d -120 /c "cmd /c del @file" 2>1 > NUL rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread David Wolverton
listserver.u2ug.org > Subject: RE: [U2] [UD] Cleaning out _PH_ > > Actually - I saw two. Both mine and Tim's used the DIR() > function to grab the date from the OS item. Tim had it in a > program and I had it buried in a program called from a dictionary. > > Perhaps ne

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread colin.alfke
Actually - I saw two. Both mine and Tim's used the DIR() function to grab the date from the OS item. Tim had it in a program and I had it buried in a program called from a dictionary. Perhaps neither of these made it to you??? Colin Alfke Calgary, Canada -Original Message- From: David

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread David Wolverton
evel 7.1 - shows Time and Date are BOTH in Attb 2 of the returned data.) David W. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 8:17 AM > To: u2-users@listserver.u2ug.or

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Brian Leach
David Since you're on Windows you can run a simple VBScript to check the dates on the entries. If you haven't used VBScript on Windows, just create the script in notepad with a vbs extension and run from a command shell using CSCRIPT scriptname.vbs or WSCRIPT scriptname.vbs - they are the same, ju

Re: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Timothy Snyder
> Have a _PH_ that is just full of crud and I cannot think of a convenient way > to automate the 'cleanup' from within UniData I usually do this with scripting at the O/S level, but you could do it with UniBasic. It would go something like this: 1) Open _PH_ with a normal OPEN statement 2) Use

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread David Wolverton
Thanks for the responses -- but the _PH_ file may contain diagnostic info we'd want - so we want it around at least 30 days -- but all the responses yield the same answer -- there is no way to know the date of the item from within UniData -- Incredible! A log file that does not have a date associa

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread colin.alfke
David; I posted a program to pickwiki that helps do this. You can setup dict items in your VOC so you can list/select in UD based on the OS size, date, etc. It should work on any DIR type file. http://www.pickwiki.com/cgi-bin/wiki.pl?GetOsInfo Colin Alfke Calgary, Canada -Original Message--

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Bill Haskett
David: Try CLEAR.ACCOUNT. This should clear both _PH_ and _HOLD_ entries. I run this every day. Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of David >Wolverton >Sent: Tuesday, January 08, 2008 8:29 PM >To: u2-users@listserver.u2ug.org >Sub

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread Symeon Breen
On windows I would use scripting and wmi to 'select' files created before a certain date - google on winmgmts, cimv2 and CIM_DataFile - on *nux it is much easier using the find command. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wol