MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador descarregar pdf (Página 246)

100

101

3 Working with Data Sources

3-18

Note: The native ODBC interface has a default batch size of 100,000 that enables

acceptable performance. To override this value, you must use setdbprefs as follows. Set

FetchInBatches to yes and set FetchBatchSize to a specific batch size number <h>.

setdbprefs('FetchInBatches','yes')

setdbprefs('FetchBatchSize','<h>')

Use fetch to import all data into the cursor object curs, and store the data in a cell

array contained in the cursor object field curs.Data.

curs = fetch(curs);

View the contents of the Data element in the cursor object curs.

curs.Data

ans =

'Victorian Doll'

'Train Set'

'Engine Kit'

'Painting Set'

'Space Cruiser'

'Building Blocks'

'Tin Soldier'

'Sail Boat'

'Slinky'

'Teddy Bear'

Export Data Using the Native ODBC Interface

Define the columns of data to insert in the cell array colnames.

colnames = {'productNumber','stockNumber','supplierNumber',...

'unitCost','productDescription'}

colnames =

Columns 1 through 3

'productNumber' 'stockNumber' 'supplierNumber'

Columns 4 through 5

1 2 ... 241 242 243 244 245 246 247 248 249 250 251 ... 683 684

Comentários a estes Manuais

Sem comentários

MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador Página 246

Comentários a estes Manuais

Manuais e produtos relacionados com Software MATLAB DATABASE TOOLBOX RELEASE NOTES