MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 504)

100

101

7 Functions — Alphabetical List

7-74

Create a DatabaseDatastore object dbds using the database connection conn and

SQL query sqlquery. This SQL query retrieves all products from the product table

productTable ordered by product number.

sqlquery = ['select * from [toy_store].[dbo].[productTable] '...

'order by productNumber'];

dbds = datastore(conn,sqlquery);

Read the data in the DatabaseDatastore object dbds.

data = read(dbds)

data =

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'

9.00 125970.00 1003.00 13.00 'Victorian Doll'

10.00 888652.00 1006.00 24.00 'Teddy Bear'

11.00 408143.00 1004.00 11.00 'Convertible'

12.00 210456.00 1010.00 22.00 'Hugsy'

13.00 470816.00 1012.00 16.50 'Pancakes'

14.00 510099.00 1011.00 19.00 'Shawl'

15.00 899752.00 1011.00 20.00 'Snacks'

data contains the query results. The preference setting 'FetchBatchSize' in

setdbprefs determines the maximum number of records read returns.

Close the DatabaseDatastore, cursor, and database connection.

close(dbds)

Retrieve Data Using a Row Count

The default output data type of any datastore is a table. Set the database preference

for the data return format 'DataReturnFormat' to table for consistency across data

types.

setdbprefs('DataReturnFormat','table')

Create a database connection conn using the native ODBC interface with Windows

Authentication. This code assumes you are connecting to a Microsoft SQL Server

1 2 ... 499 500 501 502 503 504 505 506 507 508 509 ... 683 684

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 504

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES