User`s guide

ManualsBrandsMATLAB ManualsSoftwareDATABASE TOOLBOX RELEASE NOTES

setdbprefs

7-231

setdbprefs

DataReturnFormat: 'numeric'

ErrorHandling: 'store'

NullNumberRead: '0'

NullNumberWrite: 'NaN'

NullStringRead: 'null'

NullStringWrite: 'null'

JDBCDataSourceFile: ''

UseRegistryForSources: 'yes'

TempDirForRegistryOutput: 'C:\Work'

DefaultRowPreFetch: '10000'

FetchInBatches: 'no'

FetchBatchSize: '1000'

Return Values to a Structure

Capture all preferences and their values in a structure.

Assign values for all preferences to s.

s = setdbprefs

s =

DataReturnFormat: 'cellarray'

ErrorHandling: 'store'

NullNumberRead: 'NaN'

NullNumberWrite: 'NaN'

NullStringRead: 'null'

NullStringWrite: 'null'

JDBCDataSourceFile: ''

UseRegistryForSources: 'yes'

TempDirForRegistryOutput: 'C:\Work'

DefaultRowPreFetch: '10000'

FetchInBatches: 'no'

FetchBatchSize: '1000'

Use the MATLAB tab completion feature when obtaining the value for a preference.

s.U

Press the Tab key, and then Enter. MATLAB completes the field and displays the value.

s.UseRegistryForSources