| Database Toolbox |
 |
- 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
- 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
- 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
- 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
- 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
| | Preface | |