How can I import large data through odbc (database explorer)

Dear all,

I'm trying to get 200,000 rows and 17 columns through ODBC (Database Explorer)

However, the error message related to capacity (32GB.. Limitation) came up.

I also tried to revise query sentence by choosing column name(SELECT) and value (Where).

Even though the things that satisfy my condition is 327 cases, it couldn't load my data with same error message(32GB.. Limitation).

Do you have any idea or experience to solve this problem?

Best regard,

GY.

Answer 1

[Divya Gaddipati]

A similar question has been answered which might be of relevance to you.

https://www.mathworks.com/matlabcentral/answers/457431-best-way-to-import-millions-of-rows-of-data-using-odbc-to-connect-to-as400?s_tid=answers_rc1-2_p2_MLT