Using Host Variables in Array Subscripts

Go Up to Accessing Arrays

Integer host variables can be used as array subscripts. For example, the following cursor declaration uses host variables, getval, and testval, in array subscripts:

EXEC SQL
DECLARE TC2 CURSOR FOR
SELECT CHAR_ARR[1], INT_ARR[:getval:1,1:3]
FROM TABLE1
WHERE FLOAT_ARR[:testval,1,1] = 111.0;