Creating links with foreign database

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

atoch
Posts: 15
Joined: Wed Dec 02, 2009 2:54 am
Location: Paris, France
Contact:

Creating links with foreign database

Postby atoch » Mon Dec 14, 2009 7:17 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13583
Joined: Tue Sep 16, 2008 5:38 pm

Re: Creating links with foreign database

Postby EViews Gareth » Mon Dec 14, 2009 9:04 am

Once you've defined the database in the registry you can just do:

Code: Select all

fetch(link) fra_gdp
Done!

atoch
Posts: 15
Joined: Wed Dec 02, 2009 2:54 am
Location: Paris, France
Contact:

Re: Creating links with foreign database

Postby atoch » Mon Jan 30, 2012 8:25 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13583
Joined: Tue Sep 16, 2008 5:38 pm

Re: Creating links with foreign database

Postby EViews Gareth » Mon Jan 30, 2012 12:32 pm

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?

atoch
Posts: 15
Joined: Wed Dec 02, 2009 2:54 am
Location: Paris, France
Contact:

Re: Creating links with foreign database

Postby atoch » Wed Feb 01, 2012 4:43 am

Thanks ! it worked ... as soon as I was in a program rather than in the command windows.
Sorry.

Arnaud


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests