IRIS Toolbox Reference Manual

# Basic database management

#### Loading and saving databases

- `dbload` - Create database by loading CSV file.
- `dbsave` - Save database as CSV file.
- `xls2csv` - Convert XLS file to CSV file.

#### Getting information about databases

- `dbnames` - List of database entries filtered by name and/or class.
- `dbprintuserdata` - Print names of database tseries along with specified fields of their userdata.
- `dbrange` - Find a range that encompasses the ranges of the listed tseries objects.
- `dbsearchuserdata` - Search database to find tseries by matching the content of their userdata fields.
- `dbuserdatalov` - List of values found in a specified user data field in tseries objects.

#### Converting databases

- `array2db` - Convert numeric array to database.
- `db2array` - Convert tseries database entries to numeric array.
- `db2tseries` - Combine tseries database entries in one multivariate tseries object.

#### Batch processing

- `dbbatch` - Run a batch job to create new database fields.
- `dbclip` - Clip all tseries entries in database down to specified date range.
- `dbcol` - Retrieve the specified column or columns from database entries.
- `dbfun` - Apply a function to database fields.
- `dbplot` - Plot from database.
- `dbredate` - Redate all tseries objects in a database.

#### Combining and splitting databases

- `dbextend` - Combine tseries observations from two or more databases.
- `dbmerge` - Merge two or more databases.
- `dbminuscontrol` - Create simulation-minus-control database.
- `dbsplit` - Split database into mutliple databases.

#### Overloaded operators for databases

- `-` - Remove entries from a database.
- `*` - Keep only the database entries that are on the list.
- `+` - Merge entries from two databases together.

#### Getting on-line help on database functions

    help dbase
    help dbase/function_name

IRIS Toolbox. Copyright © 2007—2013 Jaromir Benes.