DB aliases

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

DB aliases

Postby rousing » Fri Nov 15, 2013 10:01 am

Hi

I have set up a local eviews db (local_db), lets say with the following variables: series1, series2, series3.
Furthermore, I define object aliases for each of the series: a1=series1, a2=series2, a3=series3.
However, when I attempt to retrieve data in a workfile using the aliases this failes.
for instance:

Code: Select all

%request=@wquery("local_db", "name matches a*") fetch(d="local_db",link,c=l) {%request}
or

Code: Select all

fetch(d="local_db",link,c=l) a*
if I instead use the following command

Code: Select all

fetch(d="local_db",link,c=l) *
I get all the series but with the original names and not the defined aliases.

How do I proceed in order to use the alias definitions instead of the original variable names?

Thank you very much in advance for your assistance.

Best regards
Rasmus

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: DB aliases

Postby EViews Jason » Mon Nov 18, 2013 11:02 am

How do I proceed in order to use the alias definitions instead of the original variable names?
Unfortunately you cannot. Aliases were originally added to EViews to deal with illegal names when using the user interface. We are however looking into ways of better integrating aliases when using the command line.

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: DB aliases

Postby rousing » Mon Nov 18, 2013 11:40 am

Ok, thanks a lot for the clarification :)
I figured out that using a string containing all the exact alias names works with the fetch command, and this string can be obtained from the ini file controlling the aliases.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests