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

Commentaires sur ces manuels

Pas de commentaire

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

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES