User`s guide

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