ODBC Query returns 10000 rows even when it is expected to return more returnsIssue ODBC Query always returns 10000 rows even when it is expected to return more returns from the tableCauseIf the query consistently returns only 10000 rows then the most probable cause is that the query is made against a DB View on the instance and not against a table. This can be verified by navigating to the following from the application navigator on the instance: sys_db_view.list Check the table name used in the query is actually listed in the data base view.ResolutionSet the below system property: glide.db.max_view_records to a value higher than 10000.