Preface
What Is the Database Toolbox?
How Databases Connect to MATLAB
New Features
Features of the Database Toolbox
Related Products
Using This Guide
Expected Background
Organization of the Document
Online Help
Typographical Conventions
Using the Database Toolbox
Installation and Setup
System Requirements
Platforms
MATLAB Version
Databases
Drivers
Structured Query Language (SQL)
Data Types
Installing the Database Toolbox
Setting Up a Data Source
Setting Up a Local Data Source for ODBC Drivers
Setting Up a Remote Data Source for ODBC Drivers
Setting Up a Data Source for JDBC Drivers
Starting the Database Toolbox
Visual Query Builder Tutorial
About the Visual Query Builder
Visual Query Builder Interface
When to Use the Visual Query Builder
When to Use Database Toolbox Functions
Examples Using the Visual Query Builder
Online Help for the Visual Query Builder
Starting and Quitting the Visual Query Builder
Building, Running, and Saving a Query
Building and Running a Query
NULL Values
Using Retrieved Data in MATLAB
Saving a Query
Clearing Variables from the Data Area
Viewing Query Results
Relational Display of Data
Chart Display of Results
Report Display of Results in a Table
Display of Results in the Report Generator
Fine-Tuning Queries Using Advanced Query Options
Retrieving Unique Occurrences
Retrieving Information That Meets Specified Criteria
Presenting Results in Specified Order
Creating Subqueries for Values from Multiple Tables
Creating Queries for Results from Multiple Tables
Other Features in Advanced Query Options
Tutorial for Functions
Introduction
About Objects and Methods for the Database Toolbox
Importing Data into MATLAB from a Database
Viewing Information About the Imported Data
Exporting Data from MATLAB to a New Record in a Database
Exporting Data from MATLAB, Replacing Existing Data in a Database
Exporting Multiple Records from MATLAB
Accessing Metadata
Resultset Metadata Object
Performing Driver Functions
Working with Cell Arrays in MATLAB
Viewing Query Results
Retrieving Elements of Query Results
Performing Functions on Cell Arrays
Creating Cell Arrays for Exporting Data from MATLAB
Reference
Function Reference
Functions by Category
General
Database Connection
SQL Cursor
Importing Data into MATLAB from a Database
Exporting Data from MATLAB to a Database
Database Metadata Object
Driver Object
Drivermanager Object
Resultset Object
Resultset Metadata Object
Visual Query Builder
Alphabetical List of Functions
attr
bestrowid
clearwarnings
close
cols
columnnames
columnprivileges
columns
commit
confds
crossreference
database
dmd
driver
drivermanager
exec
exportedkeys
fetch
get
importedkeys
indexinfo
insert
isconnection
isdriver
isjdbc
isnullcolumn
isreadonly
isurl
logintimeout
namecolumn
ping
primarykeys
procedurecolumns
procedures
querybuilder
querytimeout
register
resultset
rollback
rows
rsmd
set
setdbprefs
sql2native
supports
tableprivileges
tables
unregister
update
versioncolumns
width
GUI Reference
Visual Query Builder Dialog Box
Starting the Visual Query Builder
Features of the Visual Query Builder
Getting Help for the Visual Query Builder
Other Database Functionality
See Also
Data Source
See Also
Tables
See Also
Fields
See Also
Advanced Query Options
See Also
All or Distinct
Example Using All and Distinct
See Also
Where
Where Clauses Dialog Box
Examples Using Where Clauses
See Also
Fields
Condition
Operator
Current clauses
Subquery
Group By
Group By Clauses Dialog Box
Example Using Group By Clauses
See Also
Having
Example Using Having Clause
See Also
Order By
Order By Clauses Dialog Box
Example Using Order By Clauses
SQL Statement
See Also
MATLAB Workspace Variable
See Also
Execute
See Also
Data
Using Retrieved Data in MATLAB
See Also
Display Menu
See Also
Display Data
Display Chart - Charting Dialog Box
Display Report
Display Report Generator
Query Menu
Execute Queries
Load Saved Queries
Save Queries
Preferences for Queries
See Also
Printable Documentation (PDF)
Product Page (Web)