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
ivContents
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
NoNoBug Reports
NoNoBug Repor
NoNoBug Reports
NoNoBug Reports
NoNoBug Re
Yes
Details
Yes
Details
Version
Compatibilit
Consideratio
NoBug Reports
NoBug 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)
NoNoBug
Yes
Details
NoNoBug Reports
NoBug 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
NoNo
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
YesNoBug 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
NoNoBug 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
NoNoBug 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
NoNoBug 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
NoNoBug 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
NoNoBug 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
NoBug 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
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 CompatibilityConsiderations 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
NoNoBug 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
NoBug 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
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
NoNoBug 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
NoNo
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 CompatibilityConsiderations,
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...
+ hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.