define external function SQLGetArrayAsCounterShelf
     (  read-only SQL_array_type Array,
        modifiable counter ReturnedShelf,
        value counter ElementCount )

Retrieves elements from the SQL_array_type variable's data contents into the counter variable as shelf items.

Input arguments:

• Array. The SQL_array_type variable to examine.
• ElementCount. The total number of elements, starting from the first, to copy to the counter shelf. This must not exceed the declared element count of Array or an exception will be raised and the program terminated.

Output argument:

• ReturnedShelf. The counter shelf into which the data is retrieved. The shelf must be declared as variable. The shelf is cleared before data is inserted.