User`s guide

Using DatabaseDatastore Objects
7-87
dbds = datastore(conn,sqlquery)
dbds =
DatabaseDatastore with properties:
Connection: [1x1 database.ODBCConnection]
Cursor: [1x1 database.ODBCCursor]
Query: 'select * from [toy_store].[dbo].[productTable] order by productNumber'
datastore executes the SQL query sqlquery and creates a cursor object with the
resulting data. dbds contains these properties:
• Database connection object
• Database cursor object
• Executed SQL query
Close the DatabaseDatastore, cursor, and database connection.
close(dbds)
• “Import Data Using a DatabaseDatastore”
• “Analyze Large Data Sets in a Database with MapReduce”
Properties
Connection — Database connection
connection object
Database connection, specified as a connection object created using database.
Cursor — Database cursor
database cursor object
Database cursor, specified as a database cursor object created using exec with the SQL
query query.
Query — SQL query
string
SQL query, specified as a string to denote the SQL query to execute in the database.
Data Types: char