Data Integration
- Data Integration
- All Products
SETVARIABLE( $$Variable, value )
Argument
| Required/
Optional
| Description
|
---|---|---|
$$
Variable
| Required
| Name of the in-out parameter you want to set. Use with in-out parameters configured with the Max or Min aggregation type.
|
value
| Required
| The value to set as the current value of the in-out parameter. You can use a valid expression that evaluates to a datatype compatible with the datatype of the parameter.
|
SETVARIABLE ($$Time, SYSDATE)
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SETVARIABLE ($$Time, TIMESTAMP)
|
|
|
|
---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What is the point of setvariable and setmaxvariable if they do they work exactly the same?
Hi Tim,
They are actually different. SETMAXVARIABLE sets the current value of an in-out parameter to the higher of the current value of the parameter or the value you specify - so if the current value is higher, it returns the current value, but if the value you specify is higher, it returns the value you specify. SETVARIABLE sets the current value of an in-out parameter to a value you specify.