How can I customize null value handling with cursor-based fetch?

MathWorks Support Team

2022 11 10

1 个回答

回答已采纳

4 次查看（30 天）

显示更早的评论

0 个投票

I am using the cursor-based 'fetch' command (from the Database Toolbox) to read data from a database. However, the way null values are read differs across operating systems. Is there a global customization I can use to dictate the way fetch reads null values? The 'databaseImportOptions'/'SQLImportOptions' functions do not work for this import method.

请先登录，再回答此问题。

请先登录再关注

采纳的回答

MathWorks Support Team 2022-11-10

0 个投票

Use the ‘setdbprefs’ function to specify how null values are read. Specifically, the “NullNumberRead” and “NullStringRead” fields specify how null numeric and character data is read into MATLAB.