User`s guide

7 Functions — Alphabetical List

7-40

ans =

Close the cursor object.

close(curs)

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

A =

[ 2101] [0]

[ 3546] [1]

[33116] [1]

[34155] [0]

[34267] [1]

View the class of the second column of A.

class(A{1,2})

ans =

logical

Close the cursor object.

close(curs)

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.