User`s guide

xii Contents

Compatibility and Limitations . . . . . . . . . . . . . . . . . . . . . . 3-21

Using Database Explorer

Working with Database Explorer . . . . . . . . . . . . . . . . . . . . . . 4-2

Getting Started with Database Explorer . . . . . . . . . . . . . . . . 4-2

Migrate from VQB to Database Explorer . . . . . . . . . . . . . . . 4-2

Set Database Explorer Preferences . . . . . . . . . . . . . . . . . . . . 4-3

Configure Data Sources and Connect to Databases . . . . . . . 4-6

Configure Your Environment . . . . . . . . . . . . . . . . . . . . . . . . 4-6

Work with Multiple Databases . . . . . . . . . . . . . . . . . . . . . . 4-17

Modify and Delete Database Connections . . . . . . . . . . . . . . 4-19

ODBC Drivers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-19

JDBC Drivers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-19

Refine Results Using Query Criteria and Rules . . . . . . . . . 4-21

Define Query Criteria to Refine Results . . . . . . . . . . . . . . . 4-21

Query Rules Using the SQL Criteria Panel . . . . . . . . . . . . . 4-22

Generate SQL and MATLAB Code . . . . . . . . . . . . . . . . . . . . . 4-25

Save Queries as SQL Code . . . . . . . . . . . . . . . . . . . . . . . . . 4-25

Generate MATLAB Code . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-26

Using Visual Query Builder

Getting Started with Visual Query Builder . . . . . . . . . . . . . . 5-2

What Is Visual Query Builder? . . . . . . . . . . . . . . . . . . . . . . . 5-2

Using Queries to Import Data . . . . . . . . . . . . . . . . . . . . . . . . 5-2

Using Queries to Export Data . . . . . . . . . . . . . . . . . . . . . . . . 5-9

Clearing Variables from the VQB Data Area . . . . . . . . . . . . 5-14

Working with Preferences . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-15