MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 470)

7 Functions — Alphabetical List

Close the cursor object.

Import Boolean Data

Import data that includes a BOOLEAN field, using the setdbprefs function to specify

cellarray as the format for the retrieved data.

curs = exec(conn,['select InvoiceNumber, '...

'Paid from Invoice']);

setdbprefs('DataReturnFormat','cellarray')

curs = fetch(curs,5);

A = curs.Data

View the class of the second column of A.

class(A{1,2})

Close the cursor object.

Perform Incremental Fetch

Working with the dbtoolboxdemo data source, retrieve data incrementally to

avoid Java heap errors. Use cursor.fetch with the setdbprefs properties for

FetchInBatches and FetchBatchSize to fetch large data sets.

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