Database Toolbox™About Objects and Methods in the Database Toolbox™ Software   Functions — Alphabetical List
  

Function Reference

Click for Alphabetical List Alphabetical List
GeneralSettings for login time, retrieval format, and more
Database ConnectionCreate, test, close, and set parameters for database connection
SQL CursorSet parameters for and execute query
Importing Data into the MATLAB® Workspace from a DatabaseImport data from database to the MATLAB® workspace, and get information about imported data
Database Metadata ObjectInformation about database data
Exporting Data from the MATLAB® Workspace to a Database Export data from the MATLAB® workspace to database
Driver ObjectConstruct and get information about database driver
Drivermanager ObjectConstruct and get information about database drivermanager
Resultset ObjectConstruct and get information about resultset
Resultset Metadata ObjectConstruct and get information about resultset metadata
Visual Query BuilderStart query builder GUI and configure JDBC data source

Back to Top

General

logintimeoutSet or get time allowed to establish database connection
setdbprefsSet preferences for retrieval format, errors, NULLs, and more

Back to Top

Database Connection

closeClose database connection, cursor, or resultset object
databaseConnect to database
getRetrieve object properties
getdatasourcesReturn names of ODBC and JDBC data sources on system
isconnectionDetect whether database connections are valid
isreadonlyDetect whether database connection is read-only
pingGet status information about database connection
setSet properties for database, cursor, or drivermanager object
setdbprefsSet preferences for retrieval format, errors, NULLs, and more
sql2nativeConvert JDBC SQL grammar to SQL grammar native to system

Back to Top

SQL Cursor

closeClose database connection, cursor, or resultset object
execExecute SQL statement and open cursor
getRetrieve object properties
querytimeoutGet time specified for SQL queries to succeed
runstoredprocedureCall stored procedure with input and output parameters
setSet properties for database, cursor, or drivermanager object

Back to Top

Importing Data into the MATLAB® Workspace from a Database

attrRetrieve attributes of columns in fetched data set
colsRetrieve number of columns in fetched data set
columnnamesRetrieve names of columns in fetched data set
cursor.fetchImport data into MATLAB® workspace from cursor object created by exec
database.fetchExecute SQL statement to import data into MATLAB® workspace
fetchcursor.fetch or database.fetch
fetchmultiImport data from multiple resultsets
querybuilderStart SQL query builder GUI to import and export data
rowsReturn number of rows in fetched data set
widthReturn field size of column in fetched data set

Back to Top

Database Metadata Object

bestrowidUnique identifier for row in database table
columnprivilegesList database column privileges
columnsReturns database table column names
crossreferenceRetrieve information about primary and foreign keys
dmdConstruct database metadata object
exportedkeysRetrieve information about exported foreign keys
getRetrieve object properties
importedkeysReturn information about imported foreign keys
indexinfoReturn indices and statistics for database tables
primarykeysGet primary key information for database table or schema
procedurecolumnsGet stored procedure parameters and result columns of catalogs
proceduresGet stored procedures for catalogs
supportsDetect whether property is supported by database metadata object
tableprivilegesReturn database table privileges
tablesReturn database table names
versioncolumnsAutomatically update table columns

Back to Top

Exporting Data from the MATLAB® Workspace to a Database

commitMake database changes permanent
insertAdd MATLAB® data to database tables (deprecated; use fastinsert instead)
querybuilderStart SQL query builder GUI to import and export data
rollbackUndo database changes
updateReplace data in database table with MATLAB® data

Back to Top

Driver Object

driverConstruct database driver object
getRetrieve object properties
isdriverDetect whether driver is a valid JDBC driver object
isjdbcDetect whether driver is JDBC compliant
isurlDetect whether database URL is valid
registerLoad database driver
unregisterUnload database driver

Back to Top

Drivermanager Object

drivermanagerConstruct database drivermanager object
getRetrieve object properties
setSet properties for database, cursor, or drivermanager object

Back to Top

Resultset Object

clearwarningsClear warnings for database connection or resultset
closeClose database connection, cursor, or resultset object
getRetrieve object properties
isnullcolumnDetect whether last record read in resultset is NULL
namecolumnMap resultset column name to resultset column index
resultsetConstruct resultset object

Back to Top

Resultset Metadata Object

getRetrieve object properties
rsmdConstruct resultset metadata object

Back to Top

Visual Query Builder

confdsConfigure JDBC data source for Visual Query Builder
querybuilderStart SQL query builder GUI to import and export data
  

About Objects and Methods in the Database Toolbox™ SoftwareAbout Objects and Methods in the Database Toolbox™ Software Functions — Alphabetical ListFunctions — Alphabetical List

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