The batch file command to clean up all the $$$ files on C: drive would look like this:
DEL C:\*.$$$ /S Be deadly careful with this. Do this first to make sure of your command finds just the files you want!!!! DIR C:\*.$$$ /S Then change DIR to DEL and you are in business. Test first on a computer you don't care about!!! NOTE: These batch files must be schedules and run on the target computer. DIR \\whatever *.$$$ /S will not work. Dennis McGrath > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of A. > Razzak Memon > Sent: Thursday, February 26, 2015 9:52 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Oterro $$$ files > > At 10:34 AM 2/26/2015, Jan Johansen wrote: > > >Razzak, > > > >Ok. In my case I can't do that as people are accessing Oterro during > >web sessions. > >I have noticed a whole lot of .$$$ files as well that I occasionally > >need to clean > >up. > > > >I can't place your suggestion anywhere (I think) as these are web > >sessions but the > >sessions are definitely not exiting cleanly. > > > Jan, > > Sure you can! > > Using the provided solution, the command will ONLY delete .$$$, if un- > locked, > and not being used by any session of R:BASE/Oterro, without ant > -ERROR- message. > > If you didn't know already, or have not paid attention, a "unique" 32 > character > file is created by each session of R:BASE eXtreme 9.5 and Oterro 9.5 engines. > Additional files are created and automatically deleted when using a huge > query, > select, sort, or when managing TEMPORARY tables/views. > > However, keep doing what you are already doing to occasionally need > to clean up. > > For the web sessions, knowing the exact folder of your default/scratch .$$$ > files, you may create a batch file to delete *.$$$ and run under MS > Windows Task > Scheduler, even in a MS Cloud environment. > > That is your tip of the day! > > Have fun! > > Very Best R:egards, > > Razzak >
