MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 506)

100

101

7 Functions — Alphabetical List

7-76

database with the data source named MS SQL Server Auth. MS SQL Server Auth

contains the table named productTable with 15 product records.

conn = database.ODBCConnection('MS SQL Server Auth','','');

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 and retrieve information info

about the database.

[data,info] = 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'

info =

datasource: 'MS SQL Server Auth'

offset: 0

data contains the query results. The structure info contains the data source name

datasource and current cursor position offset.

The preference setting 'FetchBatchSize' in setdbprefs determines the maximum

number of records read returns.

Close the DatabaseDatastore, cursor, and database connection.

1 2 ... 501 502 503 504 505 506 507 508 509 510 511 ... 683 684

Commenti su questo manuale

Nessun commento

MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Pagina 506

Commenti su questo manuale

Prodotti e manuali riguardandi Software MATLAB DATABASE TOOLBOX RELEASE NOTES