Notifications

670 views

Querying a database view table using the ODBC driver returns only 10,000 rows

 

Problem
Database view tables limit the number of records you can query at one time.

 

Symptoms
Querying a database view table using the ODBC driver returns only 10,000 records at most, even if the query should return more.

  

Cause
The system property glide.db.max_view_records limits the maximum number of database view records you can query at one time.

 

Resolution
Set the property glide.db.max_view_records to a value greater than 10,000.

Article Information

Last Updated:2015-10-16 07:54:40
Published:2015-08-14