User manual MATLAB DATABASE TOOLBOX RELEASE NOTES

[. . . ] Other product or brand names may be trademarks or registered trademarks of their respective holders. Patents The MathWorks products are protected by one or more U. S. Please see www. mathworks. com/patents for more information. Contents Summary by Version . Version 3. 7 (R2010a) Database Toolbox Software . Version 3. 6 (R2009b) Database Toolbox Software . [. . . ] New Features and Changes Yes 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 New features and changes follow. New Connection Object Methods Several new connection object methods provide database-specific information. The new methods are: · database. catalogs · database. columns · database. schemas · database. tables See the individual reference pages for more information on how to use these methods. Enhanced Error Messages New enhanced error messages to provide more information about the error. For example, the 2009b error message Drivers not Found/Loaded is now Drivers not Found/Loaded. Please verify that login information and database url are valid in 2010b. This error will appear when the driver input is valid but the database URL is invalid. 4 Version 3. 7 (R2010a) Database ToolboxTM Software Improved Write Performance New MATLAB code templates provide significant performance upgrades for fastinsert. 5 Database ToolboxTM Release Notes Version 3. 6 (R2009b) Database Toolbox Software This table summarizes new features in Version 3. 6 (R2009b). 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. If no password is required, the M-file will run as is. For more information, see "About Generated Files". 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. [. . . ] In previous versions, the contents displayed in the Command Window. You still can display the contents in the Command Window by typing the variable name in the Command Window. VQB Query Execute Updates Statement In the VQB, when you edit the SQL statement field, the query represented by the other fields does not match what is in the SQL statement field. When you then select Query > Save, it saves exactly that mismatch. When you then load that saved query, you again see the mismatch. [. . . ]