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

[U2] Last chance to nominate

2008-01-09 Thread Brian Leach
Calling all U2UG members on thist list - This is a final reminder that nominations for the U2UG board close on 10th February. To ensure your nomination gets processed in time, please email me directly on [EMAIL PROTECTED] We are looking for committed and enthusiastic candidates who want to

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 Subject:

Re: [U2] Universe 10.1 Itype possible parsing problem

2008-01-09 Thread Herve Balestrieri
This interesting feature is reproduced also at release 9.5.1 of UniVerse (and likely from the beginning), but this one was not yet referenced at IBM nor its predecessors. Note that compiling the DICTionary displays something abnormal that could alert on the problem : CD VOCLIB Compiling

Re: [U2] Universe 10.1 Itype possible parsing problem

2008-01-09 Thread john reid
I appreciate the feedback. Thanks all. john On 1/9/08, Herve Balestrieri [EMAIL PROTECTED] wrote: This interesting feature is reproduced also at release 9.5.1 of UniVerse (and likely from the beginning), but this one was not yet referenced at IBM nor its predecessors. Note that compiling the

RE: [U2] UniSQL - virtual fields problem

2008-01-09 Thread Larry Chiang
We have tried from the sql , and the ODBC. They all failed. No problems with joins using ODBC. By that I mean, we can perform joins without any problems. However, we still are not getting any results from the the virtual fields taht participating in the joins. Dave Davis [EMAIL PROTECTED]

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

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 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,

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

RE: [U2] [UD] Cleaning out _PH_

2008-01-09 Thread David Wolverton
Very cool - Thanks Colin -- I don't go review the source code on the Wiki like I probably should! This problem has already been solved - and your code does it quite nicely -- I have never used the DIR function -- hadn't even thought of it -- and that's why I was dreading the exercise since I

RE: [U2] Universe 10.1 Itype possible parsing problem

2008-01-09 Thread Jerry Banker
Chuck, Thanks for verifying it. Also thanks for letting me know about the DLIST command I was wondering if there was a way to look at an I-descriptor. Jerry Banker Sr Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org

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
The wonderful speed of the internet! I sent that response BEFORE you two sent yours! Overnight, when people suggested external scripts to use - Not that there's anything wrong with that... But I prefer something that is all trackable within PRC and with UniData control... Thanks -- the DIR()

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 21 NUL rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] [Ad] XLr8 Editor and Web Developer Updates

2008-01-09 Thread daverch
U2logic announces that our Free eclipse based plugin for Universe and Unidata has been updated. Instructions for downloading this tool is available at www.u2logic.com. Cumulative release notes: 1.3.5 - U2Plugin - The editor manages connections above the high water mark significantly better now.

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

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 out _PH_ David; I posted a