PowerCenter
- PowerCenter 10.5.1
- All Products
SETVARIABLE( $$Variable,value)
Argument
| Required/
Optional
| Description
|
---|---|---|
$$ Variable
| Required
| Name of the mapping variable you want to set. Use with mapping variables with Max/Min aggregation type.
|
value
| Required
| The value you want to set the current value of the variable to. You can enter any valid transformation expression that evaluates to a datatype compatible with the datatype of the variable.
|
SETVARIABLE ($$Time, SYSDATE)
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SETVARIABLE ($$Time, TIMESTAMP)
|
|
|
|
---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|