Version 3.2 (R2006b) Database Toolbox™ Software Release Notes

Version 3.2 (R2006b) Database Toolbox Software

This table summarizes what's new in Version 3.2 (R2006b):

New features and changes follow.

• Enhanced fetch Combines exec with existing fetch

• Import Data from Multiple Resultsets

• Run Stored Procedures to Return Output Parameters

• Specify Catalog and Schema Using Visual Query Builder

• Preferences Option to Find Additional Data Sources

• MATLAB Change to Assignment of Nonscalar Structure Array Fields Might Impact Database Toolbox Software Users

Enhanced fetch Combines exec with existing fetch

The new function, database.fetch, executes the specified SQL query and imports results into the MATLAB workspace, given the connection handle conn. It is provided for convenience, to combine capabilities of the existing exec and cursor.fetch functions. In statements and code, do not specify database.fetch or cursor.fetch but rather, just specify fetch with the appropriate objects provided as arguments; the toolbox runs database.fetch or cursor.fetch as appropriate based on the arguments.

Unlike cursor.fetch, database.fetch does not return a cursor object on which you can run subsequent Database Toolbox™ functions, but rather returns all data to a MATLAB variable. For more information about database.fetch and how it differs from cursor.fetch, see the fetch reference page, as well as the database.fetch and cursor.fetch reference pages.

Import Data from Multiple Resultsets

The new function, fetchmulti, imports data into the MATLAB workspace from multiple resultsets, which you retrieve via an exec call to a stored procedure that contains two or more select statements.

Run Stored Procedures to Return Output Parameters

The new function, runstoredprocedure, executes a stored procedure using input parameters specified in a cell array to return output parameters. This allows you to retrieve the value of a variable into a MATLAB variable. runstoredprocedure overcomes a limitation of exec; when you run a stored procedures via exec, you can only retrieve resultsets.

Specify Catalog and Schema Using Visual Query Builder

You can now specify the catalog and schema for a data source using the Visual Query Builder. The default is none, meaning you do not need to select values for them.

Preferences Option to Find Additional Data Sources

The new setdbrprefs option, UseRegistryForSources, instructs the Visual Query Builder to search theMicrosoft^® Windows^® registry to find any ODBC data sources not uncovered using the system ODBC.INI.

MATLAB Change to Assignment of Nonscalar Structure Array Fields Might Impact Database Toolbox Software Users

In Version 7.3 (R2006b) of the MATLAB software, a change was made to how a nonscalar structure array field is assigned to a single MATLAB variable. For more information, see Assigning Nonscalar Structure Array Fields to a Single Variable in the MATLAB Release Notes.

Compatibility Considerations

As a result of this change in the MATLAB software, you may need to modify your Database Toolbox M-files.

Version 3.3 (R2007a) Database Toolbox Software

Version 3.1.1 (R2006a) Database Toolbox Software