User`s guide

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.