Size Clause for the Expand Businessobject Clause

You can specify a Size clause in a expand bus (and query) command to enable streaming and return the specified number of objects per page.

For example, to expand a business object and view the only 50 results at a time using the streaming capability, use the following:

expand businessobject Part "35735" A size 50;

Streaming can be enabled for all expands (and temporary queries) through the MX_QUERY_PAGE_SIZE environment variable, through classes in the Studio Customization Toolkit, or at runtime by using the size clause in MQL temp query or expand bus commands.

Using a size of 0 is the same as not using the Size clause and the expand is streamed using the value of MX_QUERY_PAGE_SIZE or the classes in the Studio Customization Toolkit, if set. For information on MX_QUERY_PAGE_SIZE, see the Installation Guide: Optional Variables.

Enabling streaming through the Java classes usually provides the greatest improvement in performance and memory consumption.