User`s guide

Setting Database Preferences Using the setdbprefs Function
6-75
Setting Database Preferences Using the setdbprefs Function
In this section...
“About the setdbprefs Function” on page 6-75
“Allowable Properties” on page 6-75
About the setdbprefs Function
• From the Database Explorer Toolstrip, select Preferences to open the Database
Toolbox Preferences dialog box.
• Preferences are retained across MATLAB sessions.
• Regardless of the value of 'NullNumberWrite', a NULL value is always written to
the database when you input [] or NaN for a numeric data type.
• For string inputs, a NULL value is written to the database only when the input value
matches the value of 'NullStringWrite'.
Allowable Properties
DataReturnFormat and ErrorHandling Properties and Values for setdbprefs
Property Allowable Values Description
'cellarray'
(default), 'table',
'dataset',
'numeric', or
'structure'
Format for data to import into the MATLAB
workspace. Set the format based on the type of
data being retrieved, memory considerations, and
your preferred method of working with retrieved
data.
'cellarray' (default) Import nonnumeric data into MATLAB cell
arrays.
'table' Import data into MATLAB table objects. Use for
all data types. Facilitates working with returned
columns.
'DataReturnFormat'
'dataset' Import data into MATLAB dataset objects.
Use for all data types. Facilitates working with
returned columns. This option requires Statistics
and Machine Learning Toolbox.