You can configure the maximum number of records returned
from the Expanded Service API methods. This is a global parameter
and affects all of the ports.
Procedure
- In the Configuration Console, click the Setup button.
- Click the General button.
- Click the System Parameters tab.
- From the Parameter Group drop-down
menu, select the SOA parameter group.
- Click the MAX_ROWS_FETCHED system
parameter.
Note: The MAX_ROWS_FETCHED value does not affect
the values returned from the 'Configuration' ports. Setting this
value may cause the returned records for some Webservice-calls to
be truncated in a non-deterministic and database-dependent manner.
Use caution if choosing to set this System Parameter.
- In the Current Value field, type
the maximum number of records that you want returned. To
return this system parameter to its default value, type the value
that is displayed in the Default Value field,
in this field.
- Click Save.
- Restart all pipelines.