MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger pdf (Page 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.

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 470