User`s guide

7 Functions — Alphabetical List
7-230
Statement: 0
Fetch: 0
The error appears in the cursor object Message field. Furthermore, the Data field
contains empty handles because no attributes could be created. If the ErrorHandling
property is set to store, the Data field contains 0.
Close the connection.
close(conn)
Change Multiple Settings
Change multiple database preference simultaneously using setdbprefs.
Specify that NULL strings are read from the database into a MATLAB matrix of doubles
as 'NaN'.
setdbprefs({'NullStringRead';'DataReturnFormat'},...
{'NaN';'numeric'})
For details about another way to change multiple settings, see “Assign Values to a
Structure” on page 7-230.
Assign Values to a Structure
Assign values for specific preferences in a structure to let you change multiple database
preferences simultaneously.
Assign values for preferences to fields in the structure s.
s.DataReturnFormat = 'numeric';
s.NullNumberRead = '0';
s.TempDirForRegistryOutput = 'C:\Work'
s =
DataReturnFormat: 'numeric'
NullNumberRead: '0'
TempDirForRegistryOutput: 'C:\Work'
Set preferences using the values in s.
setdbprefs(s)
Run setdbprefs to check your preferences settings.