To use indicators with array fetches, declare an array of indicators of the same length as the host_variable array, and use the syntax for associating the indicator with the host variable.
Following is an example of using indicators with array fetches:
exec sql begin declare section;
int item_numbers [100];
short i_item_numbers [100];
exec sql end declare section;
...
exec sql select it_n from item.info
into :item_numbers :i_item_numbers;
...