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

Commentaires sur ces manuels

Pas de commentaire

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

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES