Page 1 of 1

Creating links with foreign database

Posted: Mon Dec 14, 2009 7:17 am
by atoch
Bonjour,

I've been able to create a link for a time series from a foreign ( local Fame ) database using Eviews 6 and 7Beta graphical user interface by following these steps :
- define the database in Eviews registry (dbsource -> c:\temp\eviews.db)
- drag & drop series from the foreign database into my workfile
- opening the series (FRA_GDP)
- changing its properties, values to select database link.
- specify the specification for database fetch (dbsource::FRA_GDP)

I'd like to do the same in an Eviews program but I could you find the proper LINK::linkto syntax.

Thanks.

Arnaud Atoch

Re: Creating links with foreign database

Posted: Mon Dec 14, 2009 9:04 am
by EViews Gareth
Once you've defined the database in the registry you can just do:

Code: Select all

fetch(link) fra_gdp
Done!

Re: Creating links with foreign database

Posted: Mon Jan 30, 2012 8:25 am
by atoch
Thanks,

I take from Eviews documentation that illegal names are automatically renamed :
From Eviews 7 command ref.pdf, p250
notifyillegal : When in a program, report illegal EViews object names. By
default, objects with illegal names are automatically
renamed. (Has no effect in the command window.)
Using the following Eviews commands get me a form prompting for eviews illegal name resolution while my understanding of the above documentation is that renamming should have been automatic.

Code: Select all

dbopen(t=fame, s=frdb_r@asap1) adb_adbQ pagecreate(page=ADBQ) q 1950:1 2013:4 fetch(link, d=adb_adbq) usa.*
Thanks

Re: Creating links with foreign database

Posted: Mon Jan 30, 2012 12:32 pm
by EViews Gareth
We haven't been able to replicate that using some test databases, it appears to work just fine for us. Could you provide some more details on exactly which database you're accessing?

Re: Creating links with foreign database

Posted: Wed Feb 01, 2012 4:43 am
by atoch
Thanks ! it worked ... as soon as I was in a program rather than in the command windows.
Sorry.

Arnaud