The schema is SYSIBM.
The TRIM_ARRAY function deletes elements from the end of an array.
The function returns a value with the same array type as array-variable but with the cardinality reduced by the value of INTEGER(numeric-expression). The result can be null; if either argument is null, the result is the null value.
The TRIM_ARRAY function is not supported for associative arrays (SQLSTATE 42884).
The TRIM_ARRAY function can only be used on the right side of an assignment statement in contexts where arrays are supported (SQLSTATE 42884).
SET RECENT_CALLS = TRIM_ARRAY(RECENT_CALLS, 1)
SET EULER_CONST = TRIM_ARRAY(SPECIALNUMBERS, 8)
The
result is that EULER_CONST will be assigned an array
with two elements, the first element value is 2.71828183 and
the second element value is the null value.