Database Toolbox

Examples


Use this example index to jump to code examples in the documentation.

Setting Up a Data Source

Setting Up a Data Source for ODBC Drivers
Setting Up a Data Source for JDBC Drivers
Example 3--Establish JDBC Connection

Visual Query Builder GUI: Importing Data

Building and Executing a Query
Specifying Preferences for NULLS, Data Format, and Error Handling
Retrieving Unique Occurrences
Retrieving Information That Meets Specified Criteria
Creating Subqueries for Values from Multiple Tables
Creating Queries for Results from Multiple Tables
Retrieving Images in Data
Importing BOOLEAN Data
Example Using VQB SQL Statement with exec Function

Visual Query Builder GUI: Displaying Results

Relational Display of Data
Chart Display of Results
Report Display of Results in a Table
Customized Display of Results in the Report Generator
Presenting Results in Specified Order
Aggregate Column Data

Visual Query Builder GUI: Exporting Data

Exporting Data Using the VQB
Exporting BOOLEAN Data
Example Using VQB MATLAB Command with insert Function

Using Database Toolbox Functions

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 from MATLAB
Exporting Multiple New Records from MATLAB
Retrieving BINARY or OTHER Java SQL Data Types
Accessing Metadata
Performing Driver Functions
Working with Cell Arrays in MATLAB

Visual Query Builder GUI: Advanced Query Options

Example Using All and Distinct
Example Creating Queries for Results from Multiple Tables
Example for Fields in Where Clauses Dialog Box
Condition
Example Using Subquery
Example Using Group By Clauses
Example Using Having Clause
Example Using Order By Clauses