Database Toolbox

Execute

Click Execute to run the query you created using the Visual Query Builder. Another way to run a query is to select Execute from the Query menu. The results of executing depend on the Data operation chosen:

• Select (for importing data into MATLAB)--Imports data into MATLAB, assigning it to the MATLAB Workspace Variable name you provided. MATLAB stores the data as a structure, numeric array, or cell array as specified in Preferences for Queries. For more information about working with cell arrays, see Working with Cell Arrays in MATLAB. If any of the data to be retrieved is a Java BINARY or OTHER type, for example, a bitmap image, you might need to process the data. See Retrieving BINARY and OTHER Java Data.
• Insert (for exporting data)--Exports data contained in the MATLAB Workspace Variable name you provided to the database.

After executing, the Data area updates to show the current MATLAB workspace, including data retrieved via the query.

Error Dialog Box

If an error dialog box appears after executing the query, the query is invalid. For example, you cannot perform a query on table and field names that contain quotation marks or for table names and field names that use your database system's reserved words.

See Also

• Visual Query Builder Dialog Box

MATLAB Workspace Variable

Data

© 1994-2005 The MathWorks, Inc.