User`s guide

Setting Database Preferences Using the setdbprefs Function
6-77
Property Allowable Values Description
'NullStringRead' Input value, for
example, 'null'
(default)
Specify how NULL strings appear after being
imported from a database into the MATLAB
workspace. Set this parameter before running
fetch.
'NullStringWrite' Input value, for
example, 'null'
(default)
Strings in the specified format, for example,
'NULL', appear as NULL after being exported
from the MATLAB workspace to a database.
Additional Properties and Values for setdbprefs
Property Allowable Values Description
'JDBCDataSourceFile' Input value, for
example, 'D:/
file.mat'
Path to MAT-file containing JDBC data
sources.
'UseRegistryForSources' 'yes' (default) or
'no'
When set to yes, VQB searches the
Microsoft Windows registry for ODBC data
sources that are not uncovered in the system
ODBC.INI file. This message might appear:
Registry editing has been disabled
by your administrator. You can ignore
this harmless message.
'TempDirForRegistryOutput'Input value, for
example, 'D:/
work'
Folder where VQB writes ODBC registry
settings when you run getdatasources.
Use when you add data sources and do
not have write access to the MATLAB
Current Folder. The default is the Windows
temporary folder, which is returned by the
command getenv('temp').
If you specify a folder to which you do not
have write access or which does not exist,
this error appears:
Cannot export
<folder-name>\ODBC.INI:
Error opening the file.
There may be a disk
or file system error.