Host structure arrays
In PL/I, C++, and C, a host structure array is a structure name having a dimension attribute. In COBOL, it is a one-dimensional table. In RPG, it is an occurrence data structure. In ILE RPG, it can also be a data structure with the keyword DIM.
A host structure array can only be referenced in the FETCH statement when using a multiple-row fetch, or in an INSERT statement when using a multiple-row insert. Host structure arrays are defined by statements of the host language, as explained in the Embedded SQL programming topic collection.
The form of a host structure array is identical to the form of a host variable reference. The reference :S1:S2 is a reference to host structure array if S1 names a host structure array. If S1 designates a host structure, S2 must be either a small integer host variable, an array of small integer host variables, or a two dimensional array of small integer host variables. In the following example, S1 is the host structure array and S2 is its indicator array.
EXEC SQL FETCH CURSOR1 FOR 5 ROWS
INTO :S1:S2;The dimension of the host structure and the indicator array must be equal.
If the host structure has m more variables than the indicator array, the last m variables of the host structure do not have indicator variables. If the host structure has m fewer variables than the indicator array, the last m variables of the indicator array are ignored. If an indicator array or variable is not specified, no variable of the host structure array has an indicator variable.
The following diagram specifies the syntax of references to an array of host structures:
>>-:--host-identifier--+-----------------------------------+--->< | .-INDICATOR-. | '-+-----------+--:--host-identifier-'
Arrays of host structures are not supported in REXX.