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 end-exec

 01 ITEM-NUMBERS S9(9) OCCURS 100 TIMES.

 01 I-ITEM-NUMBERS S9(4) OCCURS 100 TIMES.

 exec sql end declare section end-exec

...

 exec sql select it_n from item.info

     into :item-numbers :i-item-numbers end-exec.

...