User manual MATLAB DATABASE TOOLBOX RELEASE NOTES

[. . . ] Please see www. mathworks. com/patents for more information. Contents Summary by Version . Version 3. 0 (R14) Database Toolbox Software 1 4 6 7 8 9 10 11 13 16 17 20 21 22 . . . . . . . . Compatibility Summary for Database Toolbox Software . . 25 iii iv Contents Database ToolboxTM Release Notes Summary by Version This table provides quick access to what's new in each version. Version (Release) Latest Version V3. 7 (R2010a) New Features and Changes Yes Details Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site Printable Release Notes: PDF Current product documentation V3. 6 (R2009b) V3. 5. 1 (R2009a) V3. 5 (R2008b) V3. 4. 1 (R2008a) V3. 4 (R2007b) V3. 3 (R2007a) V3. 2 (R2006b) V3. 1. 1 (R2006a) V3. 1 (R14SP3) V3. 0. 2 (R14SP2) No No No No No Yes Details Yes Details No Yes Details No No No No No No No Yes Summary No No No Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes Bug Reports Includes fixes No No No No No No No No No No 1 Database ToolboxTM Release Notes Version (Release) V3. 0. 1 (R14SP1) V3. 0 (R14) New Features and Changes No Yes Details Version Compatibility Considerations No Yes Summary Fixed Bugs and Known Problems Fixed bugs Fixed bugs Related Documentation at Web Site No No Using Release Notes Use release notes when upgrading to a newer version to learn about: · New features · Changes · Potential impact on your existing files and practices Review the release notes for other MathWorksTM products required for this product (for example, MATLAB® or Simulink®). [. . . ] New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site Printable Release Notes: PDF Current product documentation There are no new features or changes in this version. 6 Version 3. 5. 1 (R2009a) Database ToolboxTM Software Version 3. 5. 1 (R2009a) Database Toolbox Software This table summarizes what's new in Version 3. 5. 1 (R2009a): New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No There are no new features or changes in this version. 7 Database ToolboxTM Release Notes Version 3. 5 (R2008b) Database Toolbox Software This table summarizes what's new in Version 3. 5 (R2008b): New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No There are no new features or changes in this version. 8 Version 3. 4. 1 (R2008a) Database ToolboxTM Software Version 3. 4. 1 (R2008a) Database Toolbox Software This table summarizes what's new in Version 3. 4. 1 (R2008a): New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No There are no new features or changes in this version. 9 Database ToolboxTM Release Notes Version 3. 4 (R2007b) Database Toolbox Software This table summarizes what's new in Version 3. 4 (R2007b): New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No There are no new features or changes in this version. 10 Version 3. 3 (R2007a) Database ToolboxTM Software Version 3. 3 (R2007a) Database Toolbox Software This table summarizes what's new in Version 3. 3 (R2007a): New Features and Changes Yes Details below Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No New features and changes follow. · "setdbprefs Accepts Structure Input" on page 11 · "Visual Query Builder Generated M-File Includes Placeholder for Password and Assigns Preferences to Structure" on page 12 · "Preference Added for Temporary Registry Output; Ensures Full Output for getdatasources" on page 12 setdbprefs Accepts Structure Input The setdbprefs function now accepts a structure as input. For example, you can run the following commands to assign values to s: s. DataReturnFormat = 'numeric'; s. ErrorHandling = 'report'; You can also do this for other setdbprefs properties whose values you want to change. Then set the preferences using the values in s by running the command: setdbprefs(s) For more information, see the setdbprefs reference page. 11 Database ToolboxTM Release Notes Visual Query Builder Generated M-File Includes Placeholder for Password and Assigns Preferences to Structure When you run a query in the Visual Query Builder and select File > Generate M-File, the resulting M-file now includes a placeholder string password in the database statement. If a password is required for the connection, such as for connections established via JDBC drivers, substitute the password for the password string. The generated M-file assigns values for the preferences to the structure s. For more information, see the setdbprefs reference page. Preference Added for Temporary Registry Output; Ensures Full Output for getdatasources When you use getdatasources to view the data sources for your system, ensure that you view all data sources by specifying a temporary, writable, output directory using the new preference, TempDirForRegistryOutput. This is useful when you add data sources and do not have write access for the MATLAB current directory, where the toolbox temporarily writes ODBC registry settings. Without write access, getdatasources does not always return data sources you added. In that event, run setdbprefs to specify a value for the TempDirForRegistryOutput preference, where the value is the full pathname to a directory for which you have write access. 12 Version 3. 2 (R2006b) Database ToolboxTM Software Version 3. 2 (R2006b) Database Toolbox Software This table summarizes what's new in Version 3. 2 (R2006b): New Features and Changes Yes Details below Version Compatibility Considerations Yes -- Details labeled as Compatibility Considerations in descriptions of new features and changes. Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No New features and changes follow. For more information, see "Assigning Nonscalar Structure Array Fields to a Single Variable" in the MATLAB Release Notes. 14 Version 3. 2 (R2006b) Database ToolboxTM Software Compatibility Considerations As a result of this change in the MATLAB software, you may need to modify your Database Toolbox M-files. 15 Database ToolboxTM Release Notes Version 3. 1. 1 (R2006a) Database Toolbox Software This table summarizes what's new in Version 3. 1. 1 (R2006a): New Features and Changes No Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No 16 Version 3. 1 (R14SP3) Database ToolboxTM Software Version 3. 1 (R14SP3) Database Toolbox Software This table summarizes what's new in Version 3. 1 (R14SP3): New Features and Changes Yes Details below Version Compatibility Considerations No Fixed Bugs and Known Problems Bug Reports Includes fixes Related Documentation at Web Site No New features and changes follow. · "fastinsert Function Added" on page 17 · "JDBC Drivers Now Supported for Visual Query Builder on Microsoft Windows Systems" on page 18 · "Define Data Sources from Within the Visual Query Builder" on page 18 · "setdbprefs Function Enhanced" on page 18 · "Dynamically Add JDBC Drivers File" on page 19 · "64-Bit FLOAT for Microsoft® SQL Server Software Is Fully Supported" on page 19 · "Generate M-File from VQB" on page 19 · "update Function Enhanced to Export Multiple Records" on page 19 · "logintimeout Function Now Supported on Linux Platforms" on page 19 fastinsert Function Added 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. 17 Database ToolboxTM Release Notes Note that the Visual Query Builder insert feature uses the insert function instead of fastinsert. JDBC Drivers Now Supported for Visual Query Builder on Microsoft Windows Systems You now can use the Visual Query Builder (VQB) with JDBC drivers on Windows platforms. 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. Define Data Sources from Within the Visual Query Builder 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. 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. [. . . ] For more information about using these data types in the Visual Query Builder or with functions, see "Retrieving BINARY or OTHER Sun Java SQL Data Types" in the Database Toolbox documentation. 22 Version 3. 0 (R14) Database ToolboxTM Software Export Using Visual Query Builder (VQB) You now can use the VQB to export data from the MATLAB workspace, and insert it into new rows in a database. For more information, see "Exporting Data from the MATLAB Workspace to a New Record in a Database" in the Database Toolbox documentation. Display Menu in VQB Now Works for Structure and Numeric Formats You now can use Display menu items in the VQB with structure and numeric formats for retrieved data as specified in Preferences or with setdbprefs. In previous releases, you could use Display menu items only for the cell array format. Spaces in VQB Tables and Fields Now Allowed You now can use the VQB for tables and fields that contain spaces in their names. They appear inside quotation marks in the VQB lists. Open Data from VQB into Array Editor When you double-click a variable in the Data field of the VQB, it now opens in the Array Editor. [. . . ]