Database Toolbox

SQL Statement or MATLAB Command

The field name shown in the VQB is based on the Data operation chosen:

• SQL Statement--Shown when the Data operation is Select (for importing data into MATLAB), it defines the query you are creating with the Visual Query Builder
• MATLAB Command--Shown when the Data operation is Insert (for exporting data from MATLAB), it defines the Database Toolbox function that exports the data using the Visual Query Builder.

SQL Statement

The SQL statement entry appears after you select Fields.

To refine the query, use the Advanced Query Options, after which the SQL statement entry updates to reflect the changes.

When you make changes to the fields in the VQB, the SQL statement reflects those changes. You can also directly edit the SQL statement entry or type a complete query into the SQL statement field.

After viewing the SQL statement, assign a MATLAB Workspace Variable for the query results.

MATLAB Command

The MATLAB command entry appears after you define the MATLAB Workspace Variable.

When you make changes to the fields in the VQB, the MATLAB command reflects those changes. You can also directly edit the MATLAB command entry. You can select and copy the entry in the MATLAB command field for use in an M-file that inserts data.

After viewing the MATLAB command, click Execute to run the query.

See Also

• Visual Query Builder Dialog Box
• Save Queries

Order By

MATLAB Workspace Variable

© 1994-2005 The MathWorks, Inc.