IBM InfoSphere DataStage, Version 11.3.1
GES function
Syntax
GES (array1, array2)
CALL -GES (return.array, array1, array2)
CALL !GES (return.array, array1, array2)
Description
Use the GES function to test if elements of one dynamic array are greater than or equal to corresponding elements of another dynamic array.
Each element of array1 is compared with the corresponding element of array2. If the element from array1 is greater than or equal to the element from array2, a 1 is returned in the corresponding element of a new dynamic array. If the element from array1 is less than the element from array2, a 0 is returned. If an element of one dynamic array has no corresponding element in the other dynamic array, the undefined element is evaluated as empty, and the comparison continues.
If either element of a corresponding pair is the null value, null is returned for that element.
If you use the subroutine syntax, the resulting dynamic array is returned as return.array.
Last updated: 2015-03-09
PDF version of this information: