User`s guide

preview
7-71
Preview the first eight records in the data set returned by executing the SQL query
sqlquery.
preview(dbds)
ans =
productNumber stockNumber supplierNumber unitCost productDescription
_____________ ___________ ______________ ________ __________________
1.00 400345.00 1001.00 14.00 'Building Blocks'
2.00 400314.00 1002.00 9.00 'Painting Set'
3.00 400999.00 1009.00 17.00 'Slinky'
4.00 400339.00 1008.00 21.00 'Space Cruiser'
5.00 400455.00 1005.00 3.00 'Tin Soldier'
6.00 400876.00 1004.00 8.00 'Sail Boat'
7.00 389123.00 1007.00 16.00 'Engine Kit'
8.00 212569.00 1001.00 5.00 'Train Set'
Close the DatabaseDatastore, cursor, and database connection.
close(dbds)
• “Import Data Using a DatabaseDatastore”
• “Analyze Large Data Sets in a Database with MapReduce”
Input Arguments
dbds — Datastore containing data in database
DatabaseDatastore object
Datastore containing data in database, specified as a DatabaseDatastore object
created using datastore.
Output Arguments
data — Query results
cell array | matrix | table | structure | dataset
Query results, returned as a cell array, matrix, table, structure, or dataset array of
the first eight records in the data set. Executing the SQL statement specified in the
DatabaseDatastore object creates the data set. The format of the data is specified by
the preference setting 'DataReturnFormat' in setdbprefs.