Dynamic array properties

When you declare a dynamic array, you can specify the following property:
maxSize
Specifies the maximum number of valid elements in the array. The default value is unbounded; the number of elements is limited only by the requirements of the target environment. Note that you can access or change this value dynamically with the dynamic array functions getMaxSize() and setMaxSize().
rowSetSize
Supports performance tuning when your code interacts with IBM® DB2® for z/OS®, as is possible when you generate for z/OS COBOL.

The rowSetSize property specifies how many rows are transferred at one time between the database management system and the EGL Runtime code. The default value is 1. If you specify a value, specify a number greater than 1.

If rowSetSize is set and is set to a larger value than maxSize and the number of rows returned in a SQL operation exceeds the maxSize value, a RuntimeException will be thrown.


Feedback