What Is the Database Toolbox?
How Databases Connect to MATLAB
Features of the Database Toolbox
Related Products
Using This Guide
Expected Background
Organization of the Document
Online Help
Typographical Conventions
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 Data Source for ODBC Drivers
Setting Up a Data Source for JDBC Drivers
Starting the Database Toolbox
Visual Query Builder
Getting Started with the Visual Query Builder
Before You Start
Starting the Visual Query Builder
Summary of Steps to Use the Visual Query Builder
Quitting the Visual Query Builder
When to Use the Visual Query Builder
When to Use Database Toolbox Functions
Examples for the Visual Query Builder
Online Help for the Visual Query Builder
Creating, Running, and Saving a Query
Building and Executing a Query
Saving a Query
Specifying Preferences for NULLS, Data Format, and Error Handling
Using Retrieved Data in MATLAB
Clearing Variables from the Data Area
Viewing Query Results
Relational Display of Data
Chart Display of Results
Report Display of Results in a Table
Customized 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
Using Functions in 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
Replacing Existing Data in a Database MATLAB
Exporting Multiple New Records from MATLAB
Accessing Metadata
Resultset Metadata Object
Performing Driver Functions
About Objects and Methods for the Database Toolbox
Working with Cell Arrays in MATLAB
Viewing Cell Array Data Returned from a Query
Viewing Elements of Cell Array Data
Performing Functions on Cell Array Data
Creating Cell Arrays for Exporting Data from MATLAB
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
Functions--Alphabetical List
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
Examples
Printable Documentation (PDF)
Product Page (Web)