Command Reference : Command Reference
  
 
dbopen
Open an existing database.
Syntax
dbopen(options) [path\]db_name [as shorthand_name]
Follow the dbopen keyword with the name of a database. You should include a path name to open a database not in the default path. The opened database will become the default database.
You do not need to specify a database name when opening a Datastream or FRED connection (“type=datastream” or “type=fred”) as EViews will automatically connect to the proper location.
You may use the “as” keyword to provide an optional shorthand_name or a short text label which is used to refer to the open database in commands and programs. If you leave this field blank, a default shorthand_name will be assigned automatically.
See “Database Shorthands” for additional discussion.
By default, EViews will use the extension of the database file to determine type. For example, files with the extension “.EDB” will be opened as an EViews database, while files with the extension “.IN7” will be opened as a GiveWin database. You may use the “type=” option to specify an explicit type.
Options
 
type=arg, t=arg
Specify the database type: (see table below).
The following table summaries the various database formats, along with the corresponding “type=” keywords:
 
 
Option Keywords
AREMOS Bank
“aremos
AREMOS TSD
“a”, “tsd”
Bloomberg
“bloom”
Bureau of Labor Statistics
“Bureau of Labor Statistics”
CEIC
“ceic”
Datastream
“datastream”
DRIBase
“b” “dribase”
DRIPro Link
“dripro”
DRI DDS
“dds”
EIA Bulk File
“eiabulk”
EIA Online
“eia”
ECB
“ECB SDMX Database”
EcoWin
“ecowin”
EViews
“e”, “eviews”
Eurostat
“Eurostat SDMX Database”
FactSet
“factset”
FAME
“f”, “fame”
FRED
“fred”
GiveWin/PcGive
“g”, “give”
Haver
“h”, “haver”
IHS Global Insight
“ihs global insight”
IHS Magellan
“magellan”
IMF
“International Monetary Fund Database”
Moody’s Economy.com
“economy”
RATS 4.x
“r”, “rats”
RATS Portable / TROLL
“l”, “trl”
SDMX_ML
“SDMX_ML Files”
TSP Portable
“t”, “tsp”
UN
“UN SDMX Database”
World Bank
“World Bank Database”
You must have EViews Enterprise Edition to access Bloomberg, CEIC, Datastream, DRIBase, EcoWin, EIA, FactSet, FAME, Haver, IHS Global Insight, IHS Magellan, and Moody’s Economy.com databases.
The use of Bloomberg, CEIC, Datastream, DRIPro Link, EcoWin, EIA, FactSet, FRED, IHS IHS Global Insight, Magellan, Economy.com, World Bank, SDMX_ML, Eurostat, UN, ECB, IMF, and Bureau of Labor Statistics databases requires an active connection to the internet.
In addition, specific types may require installation of additional software. For details see, “Notes on Particular Formats”
The following options may be required when connecting to a remote server:
 
s=server_id, server=server_id
Server name
u=user, username=user
Username
p=pwd, password=pwd
Password
Examples
dbopen c:\data\us1
opens a database named US1 in the C:\DATA directory. The command:
dbopen us1
opens a database in the default path. If the specified database does not exist, EViews will issue an error message. You should use db or dbcreate to create a new database.
Cross-references
See “EViews Databases” for a discussion of EViews databases.
See also db and dbcreate.