MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 654)

100

101

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.

1 2 ... 649 650 651 652 653 654 655 656 657 658 659 ... 683 684

Komentáře k této Příručce

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 654

Komentáře k této Příručce

Související produkty a manuály pro Software MATLAB DATABASE TOOLBOX RELEASE NOTES