Testing a Value in a Search Condition

Go Up to Accessing Arrays

A single array element’s value can be evaluated in the search condition of a WHERE clause. For example,

EXEC SQL
DECLARE TC2 CURSOR FOR
SELECT CHAR_ARR[1], INT_ARR[1:2,1:3]
FROM TABLE1
WHERE SMALLINT_ARR[1,1,1] = 111;

Important: You cannot evaluate multi-element array slices.