Learn more about Database Toolbox

Function Reference

Alphabetical List

---

Utilities Settings for login time, retrieval format, and more Database Connection Create, test, close, and set parameters for database connection SQL Cursor Set parameters for and execute query Data Import Import data from database to the MATLAB workspace, and get information about imported data Database Metadata Object Information about database data Data Export Export data from the MATLAB workspace to database Driver Object Construct and get information about database driver Drivermanager Object Construct and get information about database drivermanager Resultset Object Construct and get information about resultset Resultset Metadata Object Construct and get information about resultset metadata Visual Query Builder Start query builder GUI and configure JDBC data source

Back to Top

Utilities

logintimeout	Set or get time allowed to establish database connection
setdbprefs	Set preferences for retrieval format, errors, NULLs, and more

Back to Top

Database Connection

close	Close database connection, cursor, or resultset object
database	Connect to database
get	Retrieve object properties
getdatasources	Return names of ODBC and JDBC data sources on system
isconnection	Detect whether database connections are valid
isreadonly	Detect whether database connection is read-only
ping	Get status information about database connection
set	Set properties for database, cursor, or drivermanager object
setdbprefs	Set preferences for retrieval format, errors, NULLs, and more
sql2native	Convert JDBC SQL grammar to SQL grammar native to system

Back to Top

SQL Cursor

close	Close database connection, cursor, or resultset object
exec	Execute SQL statement and open cursor
get	Retrieve object properties
querytimeout	Get time specified for SQL queries to succeed
runstoredprocedure	Call stored procedure with input and output parameters
set	Set properties for database, cursor, or drivermanager object

Back to Top

Data Import

attr	Retrieve attributes of columns in fetched data set
cols	Retrieve number of columns in fetched data set
columnnames	Retrieve names of columns in fetched data set
cursor.fetch	Import data into MATLAB workspace from cursor object created by exec
database.fetch	Execute SQL statement to import data into MATLAB workspace
fetch	cursor.fetch or database.fetch
fetchmulti	Import data from multiple resultsets
querybuilder	Start SQL query builder GUI to import and export data
rows	Return number of rows in fetched data set
width	Return field size of column in fetched data set

Back to Top

Database Metadata Object

bestrowid	Unique identifier for row in database table
columnprivileges	List database column privileges
columns	Return database table column names
crossreference	Retrieve information about primary and foreign keys
dmd	Construct database metadata object
exportedkeys	Retrieve information about exported foreign keys
get	Retrieve object properties
importedkeys	Return information about imported foreign keys
indexinfo	Return indices and statistics for database tables
primarykeys	Get primary key information for database table or schema
procedurecolumns	Get stored procedure parameters and result columns of catalogs
procedures	Get stored procedures for catalogs
supports	Detect whether property is supported by database metadata object
tableprivileges	Return database table privileges
tables	Return database table names
versioncolumns	Automatically update table columns

Back to Top

Data Export

commit	Make database changes permanent
insert	Add MATLAB data to database tables (deprecated; use fastinsert instead)
querybuilder	Start SQL query builder GUI to import and export data
rollback	Undo database changes
update	Replace data in database table with MATLAB data

Back to Top

Driver Object

driver	Construct database driver object
get	Retrieve object properties
isdriver	Detect whether driver is valid JDBC driver object
isjdbc	Detect whether driver is JDBC compliant
isurl	Detect whether database URL is valid
register	Load database driver
unregister	Unload database driver

Back to Top

Drivermanager Object

drivermanager	Construct database drivermanager object
get	Retrieve object properties
set	Set properties for database, cursor, or drivermanager object

Back to Top

Resultset Object

clearwarnings	Clear warnings for database connection or resultset
close	Close database connection, cursor, or resultset object
get	Retrieve object properties
isnullcolumn	Detect whether last record read in resultset is NULL
namecolumn	Map resultset column name to resultset column index
resultset	Construct resultset object

Back to Top

Resultset Metadata Object

get	Retrieve object properties
rsmd	Construct resultset metadata object

Back to Top

Visual Query Builder

confds	Configure JDBC data source for Visual Query Builder
querybuilder	Start SQL query builder GUI to import and export data

About Objects and Methods in the Database Toolbox Software

Functions — Alphabetical List

© 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS