Friday, January 9, 2015
Tip of the Day: Preserving Computed Column Values When Using
UNLOAD/LOAD Commands
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.5.20909 or higher
www.rupdates.com
www.rbaseupdates.com
Section.: R:BASE Settings
Keywords: NOCALC
Did you know that users of R:BASE eXtreme 9.5 (32/64), Update 5, now
can preserve
original computed values when using UNLOAD or LOAD commands to move
data, or when
rebuilding the entire database with UNLOAD ALL?
A new database settings of NOCALC has been implemented in the latest
version and
build of R:BASE eXtreme 9.5 (32/64), Update 5, Build: 9.5.5.20109.
NOCALC allow users to preserve original computed values when using
UNLOAD/LOAD to
move data, or when rebuilding a database with UNLOAD ALL.
Syntax: SET NOCALC ON/OFF
Default: OFF
NOCALC suppresses or processes computed column expressions with the UNLOAD and
LOAD commands.
If NOCALC is set to ON, then the UNLOAD command, as it creates LOAD
statements,
will generate new "load only" commands as it starts each table. These
"load only"
commands would be CALC and NOCALC, which operate in a fashion similar to
CHECK/NOCHECK and FILL/NOFILL and NUM/NONUM commands. The UNLOAD command will
output the current values for the computed columns as it unloads the data.
In processing a LOAD command for a table, if it encounters a NOCALC command,
then regardless of the current setting for NOCALC, the LOAD command
will expect
values for every column, whether computed or not. The values from the
input would
then be stored in those columns that are computed, rather than doing
the actual
computation.
Other methods for adding rows to a table, such as APPEND , the Data
Browser, or
a form, would all still calculate each computed column. Only the LOAD command
with its special CALC/NOCALC commands could input a value into a
computed column
without doing the computation.
R:BASE eXtreme 9.5 stores the NOCALC setting with the database.
Have fun implementing NOCALC settings when using UNLOAD/LOAD routines in your
R:BASE applications.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
