Matlab fetch function freezes Matlab, even with limited rows in the fetch request.

Hi,

I'm using Matlab 2017A and the code keeps getting stuck on fetching data from a SQL 'view'. It is possible to connect to the database and to retrieve data from other Tables, but not from the table in the 'Views' folder in Microsoft SQL Server.

I don't get an error message, the code just keeps loading forever and makes Matlab freeze.

Can you help me pinpointing the reason for this behaviour?

Thanks,

Iris

Answer 1

[Nikhil]

Hi Iris,

Have you tried any other functions than fetch ? If not, have a look at the following functions which server the same purpose.

sqlread : https://www.mathworks.com/help/database/ug/database.odbc.connection.sqlread.html

select : https://www.mathworks.com/help/database/ug/database.odbc.connection.select.html

executeSQLScript : https://www.mathworks.com/help/database/ug/database.odbc.connection.executesqlscript.html

Hope this helps.