Table of Contents

Search

  1. Preface
  2. Scripting Overview
  3. Tcl Scripting
  4. SQL Scripting

Setting the Virtual Column Value

Setting the Virtual Column Value

Use the ::dbs::set_redo <
column_name
> <
object
> and ::dbs::set_undo <
column name
> <
object
> commands to set the redo and undo values of a virtual column that is named <
column_name
>.
In Tcl terms, these commands create special variables named <
column_name
> of the type '
output_column_type
' in the expression scope. The variables have some usage limitations. Copy and delete operations on type conversions are not allowed.
The following example shows a typical command:
::dbs::set_redo Virtcol1 $var
Variables and objects of '
output_column_type
' are Tcl variables that have special limitations on usage. To be processed properly, they should be created by special commands. Because of performance considerations, no symbolic analysis and name lookup is performed before actual script processing. The same situation occurs with the call.
The following command that defines "Virt1" as a virtual column is valid:
set Virt1 $a
The Virt1 variable is created with the type and value that is stored in the "a" variable. However, the variable is not mapped to the target. When a variable is associated with a type other than '
output_column_type
', all of the standard operations are permitted.

0 COMMENTS

We’d like to hear from you!