Preface
Function reference
- Function components
Constants
Operators
Dates
Functions
- Function overview
  - Aggregate functions
    - Filter conditions
  - Conversion functions
  - Data cleansing functions
  - Date functions
  - Encoding functions
  - Financial functions
  - Horizontal expansion functions
  - Numeric functions
  - Scientific functions
  - Special functions
  - String functions
  - Test functions
  - Window functions
    - Aggregate functions as window functions
    - Nested aggregate functions as window functions
- Function quick reference
- Functions in advanced mode
- %OPR_CONCAT%
- %OPR_CONCATDELIM%
- %OPR_IIF%
- %OPR_SUM%
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- AES_GCM_DECRYPT
- AES_GCM_ENCRYPT
- ASCII
- AVG
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COMPRESS
- CONCAT
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DECODE
- DECOMPRESS
- ENC_BASE64
- ERROR
- EXP
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- IS_DATE
- IS_NUMBER
- IS_SPACES
- ISNULL
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SET_DATE_PART
- SETCOUNTVARIABLE
- SETMAXVARIABLE
- SETMINVARIABLE
- SETVARIABLE
  - Differences between SETVARIABLE, SETMAXVARIABLE, and SETMINVARIABLE
- SHA256
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- STDDEV
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_FLOAT
- TO_INTEGER
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- UUID_STRING
- VARIANCE
System variables
Datatype reference

Function Reference

Back Next

SETMAXVARIABLE

Sets the current value of an in-out parameter to the higher of two values: the current value of the parameter or the value you specify. Returns the new current value.

At the end of a task session,

Data Integration

saves the final current value and writes it to the job details. Unless overridden, it uses the saved value as the initial value of the parameter for the next task session.

When used with a string in-out parameter, SETMAXVARIABLE returns the higher string based on the sort order selected in the mapping.

Use the SETMAXVARIABLE function only once for each in-out parameter in a pipeline.

Data Integration

processes in-out parameters as it encounters them in a mapping. The order in which

Data Integration

encounters variable functions in the mapping might not be the same for every task session. This could cause inconsistent results if you use the same variable function multiple times in a mapping.

You can use SETMAXVARIABLE with the Expression transformation.

Syntax

SETMAXVARIABLE( $$Variable, value )

Argument	Required/ Optional	Description
$$ Variable	Required	Name of the in-out parameter you want to set. Use in-out parameters with Max aggregation type.
value	Required	The value you want Data Integration to compare against the current value of the in-out parameter. You can enter any valid transformation expression that evaluates to a data type compatible with the data type of the parameter.

Return Value

The higher of two values: the current value of the in-out parameter or the value you specified. The return value is the new current value of the parameter.

When value
is NULL

Data Integration

returns the current value of $$Variable
.

Functions

Download Guide

Watch

Comments

Cloud Data Integration Homepage