Mathworks DATABASE TOOLBOX RELEASE NOTES

Database Toolbox™ Release Notes
How to Contact The MathWorks
www.mathworks. comp.soft-sys.matlab Newsgroup www.mathworks.com/contact_TS.html Technical Support
bugs@mathwo doc@mathworks.com Documentation error reports service@mathworks.com Order status, license renewals, passcodes
info@mathwo
com
rks.com
rks.com
Web
Bug reports
Sales, prici
ng, and general information
508-647-7000 (Phone)
508-647-7001 (Fax)
The MathWorks, Inc. 3 Apple Hill Drive Natick, MA 01760-2098
For contact information about worldwide offices, see the MathWorks Web site.
Database Toolbox™ Release N otes
© COPYRIGHT 2004–20 10 by The MathWorks, Inc.
The software described in this document is furnished under a license agreement. The software may be used or copied only under the terms of the license agreement. No part of this manual may be photocopied or reproduced in any form without prior written consent from The MathW orks, Inc.
FEDERAL ACQUISITION: This provision applies to all acquisitions of the Program and Documentation by, for, or through the federal government of the United States. By accepting delivery of the Program or Documentation, the government hereby agrees that this software or documentation qualifies as commercial computer software or commercial computer software documentation as such terms are used or defined in FAR 12.212, DFARS Part 227.72, and DFARS 252.227-7014. Accordingly, the terms and conditions of this Agreement and only those rights specified in this Agreement, shall pertain to and govern theuse,modification,reproduction,release,performance,display,anddisclosureoftheProgramand Documentation by the federal government (or other entity acquiring for or through the federal government) and shall supersede any conflicting contractual terms or conditions. If this License fails to meet the government’s needs or is inconsistent in any respect with federal procurement law, the government agrees to return the Program and Docu mentation, unused, to The MathWorks, Inc.
Trademarks
MATLAB and Simulink are registered trademarks of The MathWorks, Inc. See
www.mathworks.com/trademarks for a list of additional trademarks. 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. patents. Please see
www.mathworks.com/patents for more information.
Summary by Version ............................... 1
Contents
Version 3.7 (R2010a) Database Toolbox Software
Version 3.6 (R2009b) Database Toolbox Software
Version 3.5.1 (R2009a) Database Toolbox Software
Version 3.5 (R2008b) Database Toolbox Software
Version 3.4.1 (R2008a) Database Toolbox Software
Version 3.4 (R2007b) Database Toolbox Software
Version 3.3 (R2007a) Database Toolbox Software
Version 3.2 (R2006b) Database Toolbox Software
Version 3.1.1 (R2006a) Database Toolbox Software
Version 3.1 (R14SP3) Database Toolbox Software
..... 4
..... 6
.... 7
..... 8
.... 9
..... 10
..... 11
..... 13
.... 16
..... 17
Version 3.0.2 (R14SP2) Database Toolbox Software
Version 3.0.1 (R14SP1) Database Toolbox Software
Version 3.0 (R14) Database Toolbox Software
Compatibility Summary for Database Toolbox
Software
........................................ 25
........ 22
... 20
... 21
iii
iv Contents
SummarybyVersion
This table provides quick access to what’s new in each version. For clarification, see “Using Release Notes” on page 2 .
Database Toolbox™ Release Notes
Version (Release)
Latest Versi V3.7 (R2010a
V3.6 (R2009b)
V3.5.1 (R2009a)
V3.5 (R2
V3.4.1 (R2008a)
V3.4 (R2007b)
R2007a)
V3.3 (
V3.2 (R2006b)
on
)
008b)
New Features and Changes
Yes Details
No No Bug Reports
No No Bug Repor
No No Bug Reports
No No Bug Reports
No No Bug Re
Yes Details
Yes Details
Version Compatibilit Consideratio
No Bug Reports
No Bug Reports
Yes Summary
y
ns
Fixed Bugs and Known Problems
Includes fix
Includes fixes
ts
Includes
Includes fixes
Includes fixes
Inclu
Includes fixes
Bug Reports Includes fixes
fixes
ports
des fixes
es
Related Documentation at Web Site
Printable R elease Notes: PDF
Current product documentation
No
No
No
No
No
No
No
V3.1.1 (R2006a)
.1 (R14SP3)
V3
V3.0.2 (R14SP2)
No No Bug
Yes Details
No No Bug Reports
No Bug Reports
Reports
ludes fixes
Inc
Includes fixes
Includes fixes
No
No
No
1
Database Toolbox™ Release Notes
Version (Release)
V3.0.1 (R14SP1)
V3.0 (R14)
New Features and Changes
No No
Yes Details
Version Compatibility Considerations
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 MathWorks™ products required for this product (for example, MATLAB bugs, or compatibility considerations in other products impact you.
If you are upgrading from a software version other than the m ost recent one, review the current release notes and all interim versions. For example, when you upg rade from V1.0 to V1.2, review the release notes for V1.1 and V1.2.
®
or Simulink®). Determine if enhancements,
What Is in the Release Notes
New Features and Changes
New functionality
Changes to existing functionality
Version Compatibility Con si derations
When a new feature or change introduces a reported incompatibility between versions, the Compatibility Considerations subsection explains the impact.
2
SummarybyVersion
Compatibility issues reported after the product release appear under Bug Reports at The MathWorks™ Web site. Bug fixes can sometimes result in incompatibilities, so review the fixed bugs in Bug Reports for any compatibility impact.
Fixed Bugs and Known Problems
The MathWorks offers a user-searchable Bug Reports database so you can view Bug Reports. The development team updates this database at release time and as more information becomes available. Bug Reports include provisions for any known workarounds or file replacem ents. Information is available for bugs existing in or fixed in Release 14SP2 or later. Information is not avail able for all bugs in earlier releases.
Access Bug Reports using y our MathWorks Account.
3
Database Toolbox™ Release Notes
Version 3.7 (R2010a) Database Toolbox Software
This table summarizes new features in Version 3.7 (R2010a).
New Features and Changes
Yes No Bug Reports
Version Compatibility Considerations
New features and changes follow.
Fixed Bugs an d Known Problems
Includes fixes
New Connection Object Methods
Several new connection object metho ds provide database-specific info rm ation. 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.
Related Documentation at Web Site
Printable Release Notes: PDF
Current product documentation
Enhanced Error Messages
New e nhanced error messages to provide more information about the error. For example, the 2009b error message
Drivers not Found/Loaded. Please verify that login information and database url are valid
driver input is valid but the database URL is invalid.
in 2010b. This error will appear when the
4
Drivers not Found/Loaded is now
Version 3.7 (R2010a) Database Toolbox™ Software
Improved Write P erformance
New MATLAB code templates provide significant performance upgrades for
fastinsert.
5
Database Toolbox™ Release Notes
Version 3.6 (R2009b) Database Toolbox Software
This table summarizes new features in Version 3.6 (R2009b).
New Features and Changes
No No Bug Reports
Version Compatibility Considerations
There are no new features or changes in this version.
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
Printable Release Notes: PDF
Current product documentation
6
Version 3.5.1 (R2009a) Database Toolbox™ 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 No Bug Reports
Version Compatibility Considerations
There are no new features or changes in this version.
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
7
Database Toolbox™ 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 No Bug Reports
Version Compatibility Considerations
There are no new features or changes in this version.
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
8
Version 3.4.1 (R2008a) Database Toolbox™ 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 No Bug Reports
Version Compatibility Considerations
There are no new features or changes in this version.
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
9
Database Toolbox™ 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 No Bug Reports
Version Compatibility Considerations
There are no new features or changes in this version.
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
10
Version 3.3 (R2007a) Database Toolbox™ 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 Bug Reports
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
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
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.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 command:
s:
s by running the
setdbprefs(s)
For more information, see the setdbprefs reference page.
11
Database Toolbox™ Release Notes
Visual Query Bui Placeholder for
Password and Assigns Preferences
to Structure
When you run a qu M-File,there
database s
the as for connect the
password s
more informa
The generat more inform
ed M-file assigns values for the preferences to the structure
Preferenc Ensures Fu
When you us ensure th output di is useful MATLAB c registr return d value f full pa
at you view all data sources by specifying a temporary, writable, rectory using the new preference, when you add data sources and do not have write access for the
urrent directory, where the toolbox temporarily writes ODBC
y settings. Without write access,
ata sources you added. In that event, run
or the
thname to a directory for which you have write access.
ery in the Visual Query Builder and select File > Generate
sulting M-file now includes a placeholder string
tatement. If a password is required for the connection, such
ions established via JDBC drivers, substitute the password for
tring. If no password is required, the M-file will run as is. For
tion, see “About Generated Files”.
ation, see the
e Added for Temporary Registry Output;
ll Output for getdatasources
e
getdatasources to view the data sources for your system,
TempDirForRegistryOutput preference, where the value is the
lder Generated M-File Includes
password in
s.For
setdbprefs reference page.
TempDirForRegistryOutput.This
getdatasources does not always
setdbprefs to specify a
12
Version 3.2 (R2006b) Database Toolbox™ 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. SeealsoSummary.
New features and changes follow.
“Enhanced fetch Combines exec with Existing fetch” on page 13
“Import Data from Multiple Resultsets” on page 14
“Run Stored Procedures to Return Output P arameters” on pag e 14
“Specify Catalog and Schema Using Visual Query Builder” on page 14
“Preferences Option to Find A dditional Data Sources” on page 14
“MATLAB Change to Assignment of Nonscalar Structure Array Fields
Might Impact Database Toolbox Software Users” on page 14
Fixed Bugs an d Known Problems
Bug Reports Includes fixes
Related Documentation at Web Site
No
Enhanced fetch Combines exec with Existing fetch
The new function, database.fetch, executes the specified SQL query and imports results into the M ATL AB 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 or cur sor.fetch as appropriate based on the arguments.
database.fetch
Unlike which you can run subsequent Database Toolbox™ functions, but rather returns all data to a MATLAB variable. For more information about
cursor.fetch, database.fetch does not return a cursor object on
13
Database Toolbox™ Release Notes
database.fetch and how it differs from cursor.fetch,seethefetch
reference page, as well as the database.fetch and cursor. fetc h 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 procedure that contains two or more
Run Stored Procedures to Return Output Parameters
The new function, runstoredprocedure, executes a stored procedure using input parame ters 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
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 select values for them.
exec call to a stored
select statements.
exec, you can only retrieve resultsets.
default is none, meaning you do not need to
14
Preferences Option to Find Additional Data Sources
The new setdbrprefs option, UseRegistryForSources, instructs the Visual Query Builder to search theMicrosoft data sources not uncovered using the system
®
Windows®registry to find any ODBC
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.
Version 3.2 (R2006b) Database Toolbox™ 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 Toolbox™ 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 No Bug Reports
Version Compatibility Considerations
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
16
Version 3.1 (R14SP3) Database Toolbox™ 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 Bug Reports
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
on page 19
“Generate M-File from VQ B” on page 19
“update Function Enhanced to Export Multiple Records” on page 19
“logintimeout Function Now Supported on Linux Platforms” on page 19
Fixed Bugs an d Known Problems
Includes fixes
®
SQL Server Software Is Fully Supported”
Related Documentation at Web Site
No
fastinsert Function Added
There is a new function, fastinsert,thatyoucanuseinsteadoftheinsert function to export data about three time s more quickly than insert.Italso 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.
Whiletherearenoknownproblemswith unexpected results, return to using
fastinsert via Technical Support.
fastinsert, if you receive
insert and report the problem with
17
Database Toolbox™ Release Notes
Note that the Visual Query Builder insert feature uses the inse rt function instead of
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. 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 Toolbo x documentation.
Define Data Sources from Within the Visual Query Builder
The Visual Query Builder now includes two new items under the Query menu:
fastinsert.
18
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 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.
confds. When you define a JDBC data source, the
setdbprefs Function Enhanced
New arguments are supported for defining the JDBC data source MAT-fi le. For details, see the
setdbprefs reference page.
Version 3.1 (R14SP3) Database Toolbox™ Software
Dynamically Add
You can dynamica
classpath using
method instead
classpath.txt
have to restar statement. Th and so you need details, see Database Too
“Setting Up Data Sources for Use with JDBC Drivers” in the
64-Bit FLOA Fully Suppo
You now can software.
Generate
After run M-file c is usefu the equi
ning a query using the Visual Query Builder, you can generate an
onsisting of Database Too lbox functions that perform the query. This
l if you know how to run queries with the VQB and want to determine
valent functions, particularly the SQL statements in
lly add a JDBC drivers file to the MATLAB Java™
the MATLAB
of adding a pointer to the JDBC drivers file in your
file. The advantage of using javaaddpath is that you do not
t the MATLAB software session after running the
e d isadvantage is that this only applies to the current session
to run the
lbox documentation.
T for Microsoft SQL Server Software Is rted
retrieve 64-bit
M-File from VQB
JDBC Drivers File
javaaddpath function. You can use this
javaaddpath
javaaddpath statement in each new session. For
FLOAT data using M icrosoft
®
SQL Server™
exec and insert.
update
The upd recor equal detai
logi Plat
logintimeout function is now supported on Linux
The
Function Enhanced to Export Multiple Records
ate
function has been enhanced so that you can export multiple
ds based on different
the number of records in the array of data you are exporting. For
ls, see the reference page for
where clauses. The number of where clauses must
update.
ntimeout Function Now Supported on Linux
forms
®
platforms.
19
Database Toolbox™ Release Notes
Version 3.0.2 (R14SP2) Database Toolbox Software
This table summarizes what’s new in Version 3.0.2 (R14SP2):
New Features and Changes
No No Bug Reports
Version Compatibility Considerations
Fixed Bugs an d Known Problems
Includes fixes
Related Documentation at Web Site
No
20
Version 3.0.1 (R14SP1) Database Toolbox™ Software
Version 3.0.1 (R14SP1) Database Toolbox Software
This table summarizes what’s new in Version 3.0.1 (R14SP1):
New Features and Changes
No No
Version Compatibility Considerations
Fixed Bugs an d Known Problems
Fixed bugs
Related Documentation at Web Site
No
21
Database Toolbox™ Release Notes
Version 3.0 (R14) Database Toolbox Software
This table summarizes what’s new in Version 3.0 (R14):
New Features and Changes
Yes Details below
Version Compatibility Considerations
Yes–Details labeled as Compatibility Considerations, below. See also Summary.
New features and changes follow.
“New Data Types Supported” on page 22
“Export Using Visual Query Builder (VQB )” on page 23
“Display Menu in VQB Now Works for Structure and Numeric Formats”
on page 23
“Spaces in VQB Tables and Fields Now Allowed” on page 23
“Open Data from VQB into Array Editor” on page 23
“VQB Query Execute Updates Statement” on page 23
“Database Toolbox Functions Compilable” on page 24
“logintimeout not Supported on Linux Platforms” on page 24
Fixed Bugs an d Known Problems
Fixed bugs
Related Documentation at Web Site
No
22
“BOOLEAN Data Type s Now Represented as 1’s and 0’s” on page 24
New Data Types Supported
This toolbox softw are now supports Sun™ Java BINARY (BLOB or Binary Large Objects) and For more information about using these data types in the Visual Query Builderorwithfunctions,see“Retrieving BINARY or OTHER Sun Java SQL Data Types” in the Database Toolbox documentation.
OTHER data types, such as bitmap images and MAT-files.
Version 3.0 (R14) Database Toolbox™ Software
Export Using Vis
Younowcanuseth insert it into ne Data from the MA Database Toolb
Display Menu i Numeric Form
You now can us formats for r In previous array forma
etrieved data as specified in Preferences or with releases, you could use Display menu items only for the cell t.
Spaces in V
You now can names. Th
ey appear inside quotation marks in the VQB lists.
Open Dat
When you opens in the Comm Window
double-click a variable in the Data field of the VQB, it now
the Array Editor. In previous versions, the contents displayed in
and Window. You still can display the contents in the Command
by typing the variable name in the Command Window.
e VQ B to export data from the MATLAB workspace, and
w rows in a database. For more information, see “Exporting
TLAB Workspace to a New Record in a Database” in the
ox documentation.
n VQB Now Works for Structure and
ats
e Display menu items in the VQB with structure and numeric
QB Tables and Fields N ow Allowed
use the VQB for tables and fields that contain spaces in their
a from VQB into Array Editor
ual Query Builder (VQB)
setdbprefs.
VQB Qu
In the by the
hen select Query > Save, it saves exactly that mismatch. When you
you t
load that saved query, y ou again see the mismatch. When you execute
then
t updates, theSQL statement field to match the values in the other
it, i
ds for that query.
fiel
ery Execute Updates Statement
VQB, when you edit the SQL statement field, the query represented otherfieldsdoesnotmatchwhatisintheSQL statement field. When
Compatibility Considerations
s represents a change from previous versions in which the SQL s tatem ent
Thi
eld updated to reflect the values in the other fields when you loaded the
fi
ery, rather than when you executed it.
qu
23
Database Toolbox™ Release Notes
Database Toolbo
Because of chang Database Toolbo require the MAT
es made to the MATLAB Compiler, you can compile
x functions to create stand-alone applications that do not
LAB software.
logintimeout
On Linux platf
orms,
BOOLEAN Data
x Functions Compilable
not Supported on Linux Platforms
logintimeout is not supported.
Types Now Represented as 1’s and
0’s
Previously values were and 0’s, an see “Impor in the Data referenc
,ifyouretrieveda
returned as
d are of the MATLAB
ting BOOLEAN Data from Databases to the MATLAB W orkspace”
base Too lbox documentation, and the
epages.
Compatibility Considerations
If you ha
false,y
ve M-files that rely upon the string values for data being
ou need to modify your code to use
BOOLEAN field from a database using fetch ,the
true or false strings. Now they are returned as 1’s
logical data type. For more information,
fetch and insert function
true or
1 and 0 instead.
24
Compatibility Summary for Database Toolbox™ Software
Compatibility Summary for Database Toolbox Software
This table summarizes new features and changes that might cause incompatibilities when you upgrade from an earlier version, or wh en you use files on multiple versions. Details are provided in the description of the new feature or change.
Version (Release) New Features and Changes with
Version Compatib ility Impact
Latest Version V3.7 (R2010a)
V3.6 (R2009b)
V3.5.1 (R2009a)
V3.5 (R2008b)
V3.4.1 (R2008a)
V3.4 (R2007b)
V3.3 (R2007a)
V3.2 (R2006b) See the Compatibility
V3.1.1 (R2006a)
V3.1 (R14SP3)
V3.0.2 (R14SP2)
None
None
None
None
None
None
None
Considerations subheading for this change:
“MATLAB Change to Assignment
of Nonscalar Structure Array Fields Might Impact Database Toolbox Software Users” on page 14
None
None
None
25
Database Toolbox™ Release Notes
Version (Release) New Features and Changes with
Version Compatib ility Impact
V3.0.1 (R14SP1)
None
V3.0 (R14) See the Compatibility
Considerations subheading for each of these new features and changes:
“VQB Query Execute Updates
Statement” on page 23
“BOOLEAN Data Types Now
Represented as 1’s and 0’s” on page 24
26
Loading...