Karen:
You're right to be cautious. Your experience in another context taught me to take advantage of dedicated TEMP paths whenever an application provides for it. And certainly to get as much TEMP file creation as is possible off of the C: drive and onto a 'DATA' drive to minimize fragmentation and opportunity for accident on the application drive. D:\ is my data drive XX\ is a root tempfile folder hosting several application dedicated tempfile subfolders: ACAD\ DCAD\ EXCEL\ RBTEMP\ being unambiguously named. If I really had the need, I could place RBTEMP on a separate hard drive and get as close to concurrency between database and temp I/O activity with a screaming-wicked drive controller. Like I'm even CLOSE to being there. Hope this helps. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Friday, July 19, 2013 10:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Tip of the Day: Finding Default vs. ActiveSCRATCH Settings I hate to always have to mention this, but be careful with the chkfile! I once had this code for a c:\temp directory and guess what... The user actually had a file called "temp" in the root c:\ directory so it wouldn't create the directory! Karen -----Original Message----- From: Dennis McGrath <[email protected] <mailto:[email protected]> > To: RBASE-L Mailing List <[email protected] <mailto:[email protected]> > Sent: Fri, Jul 19, 2013 11:56 am Subject: [RBASE-L] - RE: Tip of the Day: Finding Default vs. ActiveSCRATCH Settings Even better: --Scratch File Location Set var vMyScratch TEXT = 'D:\XX\RBTEMP' IF (CHKFILE(.vMyScratch )) = 1 THEN GOTO SetScratch ELSE MKDIR .vMyScratch ENDIF LABEL SetScratch SET SCRATCH .vMyScratch Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] <mailto:[email protected]> -----Original Message----- From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of Bruce A. Chitiea Sent: Friday, July 19, 2013 10:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tip of the Day: Finding Default vs. Active SCRATCH Settings Thanks very much, Razzak. May I add, for any who might like to take advantage of the SET SCRATCH <PATH> feature: To ensure that an active SET SCRATCH <PATH> is always available, I include this code - cribbed from a long-ago Razzak email I believe - in my Startup File. --Scratch File Location IF (CHKFILE('D:\XX\RBTEMP')) = 1 THEN GOTO SetScratch ELSE MKDIR 'D:\XX\RBTEMP' ENDIF LABEL SetScratch SET SCRATCH 'D:\XX\RBTEMP' Hope this helps. Bruce Chitiea SafeSectors, Inc. eCondoMetrics 909.238.9012 Cell -----Original Message----- From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of A. Razzak Memon Sent: Thursday, July 18, 2013 11:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: Finding Default vs. Active SCRATCH Settings Friday, July 19, 2013 Tip of the Day: Finding Default vs. Active SCRATCH Settings Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.3.20718 or higher www.rupdates.com <http://www.rupdates.com/> Settings: SCRATCH (CVAL('SCRATCH')) function returns the value of the currently active SCRATCH setting. SET SCRATCH sets the drive and directory location for temporary (.$$$) files created when managing TEMPORARY Table, TEMPORARY Views, TEMPORARY SATTACHed Tables, and Sorting data. When using the SET SCRATCH ON, the temporary (.$$$) files are stored in the database drive and directory. When using the SET SCRATCH OFF, the temporary (.$$$) files are stored in the current (startup) drive and directory. When using the SET SCRATCH TMP, (default configuration), the temporary (.$$$) files are stored in the Windows User Environment Variables folder set for TMP folder. When using the manual SET SCRATCH <path>, the temporary (.$$$) files are stored in the defined path folder location. When doing so, make sure that the folder does exist, and the user has Full Control and permission to such folder. By default, R:BASE configuration files include the TMP for SCRATCH setting. This default will allow R:BASE or Oterro sessions to use the user's TMP environment settings for SCRATCH files on startup and eliminate all issues related to setting the SCRATCH directory and related files. To take advantage of this setting, use the option "SCRATCH TMP" in the appropriate R:BASE and OTERRO configuration files. You may also use the "SET SCRATCH TMP" command in your application startup files. Using the SET SCRATCH <ValidPathAndFolder> command at the R> prompt, in a command file or in application startup file, will overwrite the default SCRATCH setting defined in the R:BASE eXtreme 9.5 Configuration file. Using the SET SCRATCH <path> command, and providing the invalid path and folder will result in an -ERROR- as follows: -ERROR- Cannot create temporary file. (2964) In that case, make sure that you provide the correct path and folder with full control and permissions. In a scenario where you have overwritten the default SCRATCH setting, did you know that the R:BASE "Settings" option will show you the Default and Active SCRATCH settings? Here's how: R:BASE eXtreme 9.5 (32/64) | Database Explorer | Main Menu | Settings | Configuration Settings ... Configuration Settings | Scratch ... Notice the illustration, including: [x] TMP (to store temporary files in user environment TMP directory) Default SCRATCH Location: Active SCRATCH Location: Stay productive, my friends! Very Best R:egards, Razzak. www.rbase.com <http://www.rbase.com/> www.facebook.com/rbase <http://www.facebook.com/rbase> www.RazzakMemon.com <http://www.razzakmemon.com/> -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
