User`s guide

xiv Contents
Import Data from Databases into MATLAB . . . . . . . . . . . . . . 6-4
Create a Query Using a Date . . . . . . . . . . . . . . . . . . . . . . . . . . 6-8
Create a Query Using a String . . . . . . . . . . . . . . . . . . . . . . . . 6-10
Create a Query Using a MATLAB Variable . . . . . . . . . . . . . 6-12
Create a Query Using Special Characters . . . . . . . . . . . . . . 6-14
Delete Data from Databases . . . . . . . . . . . . . . . . . . . . . . . . . . 6-16
Exporting Data to New Record in Database . . . . . . . . . . . . 6-18
Replacing Existing Database Data with Exported Data . . . 6-21
Exporting Multiple Records from the MATLAB Workspace 6-22
Exporting Data Using Bulk Insert . . . . . . . . . . . . . . . . . . . . . 6-26
About Bulk Insert Functionality . . . . . . . . . . . . . . . . . . . . . 6-26
Bulk Insert into Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-26
Bulk Insert into Microsoft SQL Server 2005 . . . . . . . . . . . . 6-28
Bulk Insert into MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-30
Retrieve Image Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . 6-32
Display Database Metadata . . . . . . . . . . . . . . . . . . . . . . . . . . 6-34
Using Driver Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-37
About Database Toolbox Objects and Methods . . . . . . . . . . 6-39
Selecting Data Using the exec Function . . . . . . . . . . . . . . . . 6-40
About the exec Function . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-40
Using Cursor Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-40
Working with Microsoft Excel . . . . . . . . . . . . . . . . . . . . . . . 6-41
Database Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-41
Call a Stored Procedure That Returns Data . . . . . . . . . . . . 6-42
Run a Custom Database Function . . . . . . . . . . . . . . . . . . . . . 6-46