IBM InfoSphere DataStage, Version 11.3.1
EQS function
Syntax
EQS (array1, array2)
CALL -EQS (return.array, array1, array2)
CALL !EQS (return.array, array1, array2)
Description
Use the EQS function to test if elements of one dynamic array are equal to the elements of another dynamic array.
Each element of array1 is compared with the corresponding element of array2. If the two elements are equal, a 1 is returned in the corresponding element of a dynamic array. If the two elements are not equal, a 0 is returned. If an element of one dynamic array has no corresponding element in the other dynamic array, a 0 is returned. 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 returns as return.array.
Example
A=1:@VM:45:@SM:3:@VM:"one"
B=0:@VM:45:@VM:1
PRINT EQS(A,B)
This is the program output:
0V1S0V0
Last updated: 2015-03-09
PDF version of this information: