Indicator arrays

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.

Example

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;

...