Database Toolbox

MATLAB Workspace Variable

In the MATLAB workspace variable field, assign a name for the data that the query uses. How the VQB uses the data is based on the Data operation chosen:

• Select (for importing data into MATLAB)--After you execute the query, the variable contains the imported data.
• Insert (for exporting data)--The variable contains the data that will be exported when you execute the query.

  

Variable for Select Data Operation

When you import data, use an existing variable or create a new one. If you use an existing variable, its value will be replaced by the query results when you execute the query.

After assigning the workspace variable, click Execute to run the query.

The MATLAB workspace variable you assign appears in the Data area after you execute the query. The Data area also shows other MATLAB workspace variables used in the current MATLAB session.

If you change the selection in Tables or change the Data Source after having assigned the workspace variable, you need to reassign the workspace variable.

Variable for Insert Data Operation

When you export data, use an existing variable. After assigning the variable, press Enter or Return to update the MATLAB command, and then click Execute to run the query. After executing the query, the Data area updates, showing the current workspace.

When you load a saved query that exports data, the variable name loads as part of the MATLAB command. Type that MATLAB workspace variable name or the name of any variable in the current workspace. When you specify a different name and press Return or Enter, it updates the variable name for the MATLAB command.

See Also

• Visual Query Builder Dialog Box

SQL Statement or MATLAB Command

Execute

© 1994-2005 The MathWorks, Inc.