| Version 3.1 (R14SP3) Database Toolbox™ Software Release Notes | |
This table summarizes what's new in Version 3.1 (R14SP3):
| New Features and Changes | Version Compatibility Considerations | Fixed Bugs and Known Problems | Related Documentation at Web Site |
|---|---|---|---|
| Yes Details below | No | Bug Reports Includes fixes | No |
New features and changes follow.
JDBC Drivers Now Supported for Visual Query Builder on Microsoft Windows Systems
64-Bit FLOAT for Microsoft SQL Server Software Is Fully Supported
There is a new function, fastinsert, that you can use instead of the insert function to export data about three times more quickly than insert. It also allows exporting for all object types, so that any data you can retrieve from a database you now can export to the database, including binary objects.
While there are no known problems with fastinsert, if you receive unexpected results, return to using insert and report the problem with fastinsert via Technical Support.
Note that the Visual Query Builder insert feature uses the insert function instead of fastinsert.
You now can use the Visual Query Builder (VQB) with JDBC drivers on Windows platforms. Previously, only ODBC drivers were supported.
The confds function now displays an enhanced dialog box you use to define JDBC data sources. With it, you save and load data source information via MATLAB MAT-files.
For details, see Setting Up Data Sources for Use with JDBC Drivers in the Database Toolbox documentation.
The Visual Query Builder now includes two new items under the Query menu:
Define ODBC Data Source—Directly access your Windows ODBC Data Source Administrator dialog box where you define ODBC data sources.
Define JDBC Data Source—Access the Define JDBC Data Source dialog box for defining JDBC data sources to use with the VQB. The function equivalent is confds. When you define a JDBC data source, the information is saved in a MAT-file so you can use it again in a later session. Later, open the MAT-file using the Define JDBC Data Source dialog box, or using setdbprefs('JDBCDataSourceFile','fullpathtomatfile').
For details, see Configuring Your Environment in the Database Toolbox documentation.
New arguments are supported for defining the JDBC data source MAT-file. For details, see the setdbprefs reference page.
You can dynamically add a JDBC drivers file to the MATLAB Java™ classpath using the MATLAB javaaddpath function. You can use this method instead of adding a pointer to the JDBC drivers file in your classpath.txt file. The advantage of using javaaddpath is that you do not have to restart the MATLAB software session after running the javaaddpath statement. The disadvantage is that this only applies to the current session and so you need to run the javaaddpath statement in each new session. For details, see Setting Up Data Sources for Use with JDBC Drivers in the Database Toolbox documentation.
You now can retrieve 64-bit FLOAT data using Microsoft® SQL Server™ software.
After running a query using the Visual Query Builder, you can generate an M-file consisting of Database Toolbox functions that perform the query. This is useful if you know how to run queries with the VQB and want to determine the equivalent functions, particularly the SQL statements in exec and insert.
The update function has been enhanced so that you can export multiple records based on different where clauses. The number of where clauses must equal the number of records in the array of data you are exporting. For details, see the reference page for update.
The logintimeout function is now supported on Linux® platforms.
| Version 3.1.1 (R2006a) Database Toolbox Software | Version 3.0.2 (R14SP2) Database Toolbox Software | |
| © 1984-2008- The MathWorks, Inc. - Site Help - Patents - Trademarks - Privacy Policy - Preventing Piracy - RSS |