| Database Toolbox |
 |
- 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
- 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
- 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
- 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
- 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
- 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
| | Getting Started | |