User`s guide

7 Functions — Alphabetical List
7-224
NullNumberRead: '0'
NullNumberWrite: 'NaN'
NullStringRead: 'null'
NullStringWrite: 'null'
JDBCDataSourceFile: 'C:\hold_x\jdbcConfig_test.mat'
UseRegistryForSources: 'yes'
TempDirForRegistryOutput: 'C:\Work'
DefaultRowPreFetch: '10000'
FetchInBatches: 'no'
FetchBatchSize: '1000'
For details about what each property and value mean, see “Setting Database Preferences
Using the setdbprefs Function” on page 6-75.
Change a Preference
Set a database preference to another value.
Display the current value of the NullNumberRead database preference.
setdbprefs('NullNumberRead')
NullNumberRead: 'NaN'
Each NULL number in the database is read into the MATLAB workspace as NaN.
Change the value of this preference to 0.
setdbprefs('NullNumberRead','0')
Each NULL number in the database is read into the MATLAB workspace as 0.
Change the DataReturnFormat Preference
Changing the database preference DataReturnFormat affects the way data is returned
to the MATLAB workspace.
Specify that database data be imported into MATLAB cell arrays.
setdbprefs('DataReturnFormat','cellarray')
Establish connection conn to a MySQL database with user name username and
password pwd. This database contains the table producttable with these columns:
productnumber and productdescription.