Home
Login
Sign Up
Home
Login
Sign Up
 
 

Site Menu

Message
What are the current record limits for APIs to return
John Panzenhagen *MUGA
BC:

Question:

Article:

What are the current record limits for APIs to return

Categorized as:

API

I remember that the limitation on how many records are returned by EXPORTMI and CMS100MI have been increased, but I cannot remember to how much. Is it currently 10,000?
Delivered Read
Categorized as:
API
Group: *MUGA
1
163
Latest msg: When an index is not used, the result set is limited to 10,000 rows. However, there is no row limit when the query uses a table index. For example:... from Eric Pronovost, on 12/19/2025
Comments (1) (Descending Chronological Order)
There are no comments at this time, be the first to comment
Eric Pronovost
BC:
When an index is not used, the result set is limited to 10,000 rows. However, there is no row limit when the query uses a table index.

For example:
select * from MITMAS;
This query will return a maximum of 10,000 rows.

In contrast:
select MMITNO, MMFUDS
from MITMAS00
where MMITNO ‘ABC’;

This query uses an indexed field and will return all matching rows in the table, with no row limit applied.
2

Online