User`s guide

6 Using Database Toolbox Functions
6-76
Property Allowable Values Description
'numeric' Import data into MATLAB matrix of doubles.
Nonnumeric data types are considered NULL
and appear as specified in the NullNumberRead
property. Use only when data to retrieve is in
numeric format, or when nonnumeric data to
retrieve is not relevant.
'structure' Import data into a MATLAB structure. Use for
all data types. Facilitates working with returned
columns.
'store' (default),
'report', or 'empty'
Specify how to handle errors when importing
data. Set this parameter before you run exec.
'store' (default) Errors from running database are stored in
the Message field of the returned connection
object. Errors from running exec are stored in
the Message field of the returned cursor object.
'report' Errors from running database or exec appear
immediately in the Command Window.
'ErrorHandling'
'empty' Errors from running database are stored in
the Message field of the returned connection
object. Errors from running exec are stored in
the Message field of the returned cursor object.
Objects that cannot be created are returned as
empty handles ([ ]).
Null Data Handling Properties and Values for setdbprefs
Property Allowable Values Description
'NullNumberRead' Input value, for
example, '0'
Specify how NULL numbers appear after
being imported from a database into the
MATLAB workspace. NaN is the default value.
String values such as 'NULL' cannot be set if
'DataReturnFormat' is set to 'numeric'. Set
this parameter before running fetch.
'NullNumberWrite' Input value, for
example, 'NaN'
(default)
Numbers in the specified format, for example,
NaN appears as NULL after being exported from
the MATLAB workspace to a database.