Page 1 of 1

DB aliases

Posted: Fri Nov 15, 2013 10:01 am
by rousing
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

Re: DB aliases

Posted: Mon Nov 18, 2013 11:02 am
by EViews Jason
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.

Re: DB aliases

Posted: Mon Nov 18, 2013 11:40 am
by rousing
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.