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
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
www.facebook.com/rbase
www.RazzakMemon.com
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
