User`s guide

7 Functions — Alphabetical List
7-64
sqlquery = 'select * from productTable';
dbds = datastore(conn,sqlquery)
dbds =
DatabaseDatastore with properties:
Connection: [1x1 database.ODBCConnection]
Cursor: [1x1 database.ODBCCursor]
Query: 'select * from productTable'
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
Display the database connection property Connection.
dbds.Connection
ans =
ODBCConnection with properties:
Instance: 'MySQL'
UserName: 'username'
Message: []
Handle: [1x1 database.internal.ODBCConnectHandle]
TimeOut: 0
AutoCommit: 0
Type: 'ODBCConnection Object'
The Message property is blank when the database connection is successful.
Display the database cursor property Cursor.
dbds.Cursor
ans =
ODBCCursor with properties: