MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 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

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 654

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES