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.
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.
dbcomment
- Create model-based comments for database tseries entries.
dbfun
- Apply 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-2015 IRIS Solutions Team.