User`s guide

Working with Preferences
5-17
Preference Acceptable Values Description
numbers
as:
as NaN. Setting this field to 0 causes NULL data imported into the
MATLAB workspace to appear as 0s.
Write
NULL
strings as:
null (default) Specifies how NULL strings appear after being exported to a
database. This setting does not apply to Database Explorer.
Write
NULL
numbers
as:
Nan (default) Specifies how NULL numbers appear after being exported to a
database. This setting does not apply to Database Explorer.
Data
return
format
cell array,
numeric,
structure, or
dataset
Select a data format based on the type of data you are importing,
memory considerations, and your preferred method of working
with retrieved data.
• cellarray (default) — Imports nonnumeric data into
MATLAB cell arrays.
• numeric — Imports data into MATLAB matrix of doubles.
Nonnumeric data types are considered NULL and appear
as specified in the Read NULL numbers as: setting. Use
only when data to retrieve is in numeric format, or when
nonnumeric data to retrieve is not relevant.
• structure — Imports data into a MATLAB structure. Use for
all data types. Facilitates working with returned columns.
• dataset — Imports data into MATLAB dataset objects. This
option requires Statistics and Machine Learning Toolbox™.
This setting does not apply to Database Explorer. If you are using
Database Explorer, the data return format is specified using the
Imported Data panel in Database Explorer.
Error
handling
store, report,
or empty
• Set this field to store or empty to direct errors to either a
dialog box when using Visual Query Builder or a message field
when using the Database Toolbox command line interface.
• Set this field to report to display query errors in the
Command Window.
This setting does not apply to Database Explorer.