32
ICC
•
The
Indirect Copy
operation outputs the value at the database location
specified by the input source to the database location specified by the output
destination. This operation can be used to access different database
locations dynamically. It could also be used to create reusable database
logic subroutines by selecting a different input and output location for the
subroutine during each execution cycle.
•
The
Shift
operation outputs the input value bit-shifted by the shift amount.
•
The
Compare
operation outputs a “1” if the comparison evaluates to true,
otherwise it outputs a “0”.
•
The
Flag Test & Set
operation tests if the bit flags specified in the input mask
are set in the input value and sets the bit flags specified in the output mask
in the output value. This operation can test for ALL flags set/cleared or ANY
flags set/cleared. If the flag test evaluates as true, all bit flags specified in the
output mask in the output value are set, otherwise the flags are cleared.
Only the bits specified in the output mask in the output value are modified by
this operation.
•
The
Value Change Detection
operation outputs a “1” if a change is detected
in the input value between the last execution cycle and the current execution
cycle, otherwise it outputs a “0”.
•
The
Mutiplexer
operation outputs one of its two inputs, depending on the
selection. If
Selection
is zero,
Input 1
is output. If
Selection
is non-zero,
Input
2
is output.
•
The
Byte Reverse
operation reverses the byte order of the input value and
outputs the result.
Arithmetic Operations
•
The
Add
operation calculates the expression
[Input 1] + [Input 2]
.
•
The
Subtract
operation calculates the expression
[Input 1] – [Input 2]
.
•
The
Multiply
operation calculates the expression
[Input 1] × [Input 2]
.
•
The
Divide
operation calculates the expression
[Input 1] / [Input 2]
.
•
The
Modulo
operation calculates the expression
[Input 1] mod [Input 2]
.
•
The
Exponential
operation calculates the expression
[Input 1]
Exponent
. “Input
1” can be a database value, a constant value, or e (exponential function).
•
The
Nth Root
operation calculates the expression
�
Input 1
Degree
.
•
The
Logarithm
operation calculates the expression
log
Base
(Input 1)
. “Base”
can be a database value, a constant value or e (natural logarithm).
•
The
Random
operation outputs a random number between
Input 1
and
Input
2
. Note that the operation is limited to producing only 32,768 unique values.
•
The
Divide
,
Exponential
,
Nth Root
and
Logarithm
operations output an
integer-rounded value when an integer data type is used.
Trigonometric Operations
•
The
Sine
operation calculates the expression
sin(Input 1)
, where
Input1
is in
radians.
