Syntax
define external function SQLGetArrayAsStreamShelf
( read-only SQL_array_type Array,
modifiable stream ReturnedShelf,
value counter ElementCount )
Purpose
Retrieves elements from the SQL_array_type variable's data contents into the stream 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 stream 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.
|