User`s guide

v
Contents
Before You Begin
1
Database Toolbox Product Description . . . . . . . . . . . . . . . . . 1-2
Key Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2
Working with Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Connecting to Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Platform Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Database Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Driver Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4
Structured Query Language (SQL) . . . . . . . . . . . . . . . . . . . . 1-5
Data Type Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
Data Retrieval Restrictions . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8
Spaces in Table Names or Column Names . . . . . . . . . . . . . . 1-8
Quotation Marks in Table Names or Column Names . . . . . . . 1-8
Reserved Words in Column Names . . . . . . . . . . . . . . . . . . . . 1-8
Creating and Running SQL Queries . . . . . . . . . . . . . . . . . . . . 1-9
Getting Started with Database Toolbox
2
Working with a Database and MATLAB . . . . . . . . . . . . . . . . . 2-3
Connection Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-6
Creating or Connecting to a Data Source . . . . . . . . . . . . . . . 2-6
Defining Operating System Authentication . . . . . . . . . . . . . . 2-6
Connection Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-6
Working with Multiple Databases . . . . . . . . . . . . . . . . . . . . . 2-8