You could of course ESEARCH for the string "ompleted." And when that produces a select list, smash them to hell and back.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Symeon Breen Sent: 30 November 2011 19:40 To: 'U2 Users List' Subject: Re: [U2] I-Type question in &PH& Or if you are on *nix something like find /usr/ud/accounts/accountname/_PH_ -mtime +2 -exec rm -rf {} \; deletes anything over 2 days old -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Colin Alfke Sent: 30 November 2011 16:37 To: 'U2 Users List' Subject: Re: [U2] I-Type question in &PH& UniData has the _PH_ file which is a DIR type file. There is the DIR() function that will return a lot of information for you without the expense of opening the file. Perhaps UniVerse has something similar. See <http://www.pickwiki.com/cgi-bin/wiki.pl?GetOsInfo> for examples and code on how to use it to get the OS date/time/size quickly and easily. hth Colin Calgary, Canada -----Original Message----- From: Perry Taylor If you don't want to mess with the "nuances" of the &PH& ID you can call a subroutine which does an OPENSEQ then uses STATUS to get the modification date right from the file system. Perry ----- Original Message ----- From: Charles Stevenson You can also get elapsed time by subtracting that ID date-time stamp from the os's date-time-modified stamp, which is when the job ended. (if the job writes to the &PH& log as it ends.) On 11/29/2011 4:01 PM, John Thompson wrote: > Yep... need more sleep. Thanks. > > On Tue, Nov 29, 2011 at 4:58 PM, Wjhonson wrote: > >> Third field, not second field >> FIELD(@ID,'_',3) >> >> -----Original Message----- >> From: John Thompson >> >> >> So I thought I would build an I-type to get the date of the&PH& items >> in niverse so I could more easily purge them... >> The item id looks like so: >> AUTOMATED.UPDATE.REO_23400_15641 >> The friendly manual says that the item id is: >> hantomverb_time_date >> So my I-type looks like so: >> 001 I >> 02 FIELD(@ID,'_',2) >> 03 >> 04 Date >> 05 10 >> 06 R >> And of course, I have not put in the conversion code yet... >> The output of the I-type is this: >> ID...................................... >> Date...... >> AUTOMATED.UPDATE.REO_23400_15641 234000000.0 >> What am I missing? >> Shouldn't Date be 15641? >> -- >> ohn Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4047 - Release Date: 11/29/11 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== lIy9jFKn4LiZyzlRHz9PH0wlkCR7TUWOqrbd8XIx2vetQ== to report this email as spam. -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
