Database Toolbox User's Guide
  Go to function:
    Search    Help Desk 

Commands Grouped by Purpose

The tables below group Database Toolbox commands by purpose.

Database Connection
Command
 Purpose
close
 Close database connection.
database
 Connect to database.
get
 Get property of database connection.
logintimeout
 Set or get time allowed to establish database connection.
ping
 Get information about database connection.
set
 Set autocommit flag for database.

SQL Cursor
Command
 Purpose
close
 Close database cursor.
exec
 Execute SQL statement and open cursor.
get
 Get property of database connection.
querytimeout
 Get time allowed for database SQL query to succeed.
set
 Set rowlimit for fetch.

Importing Data into MATLAB from a Database
Command
 Purpose
attr
 Get attributes of columns in fetched data set.
cols
 Get number of columns in fetched data set.
columnnames
 Get names of columns in fetched data set.
fetch
 Import data into MATLAB cell array.
get
 Get property of cursor structure.
rows
 Get number of rows in fetched data set.
width
 Get field size of column in fetched data set.

Exporting Data from MATLAB to a Database
Command
 Purpose
insert
 Export MATLAB cell array data into database table.
update
 Replace data in database table with data from MATLAB cell array.


[ Previous | Help Desk | Next ]