Page 1 of 1

Wildcard character when querying IHS Magellan

Posted: Fri Apr 22, 2016 6:48 am
by jthodge
The "@" symbol in the name of many series in the IHS Magellan databanks appears to be causing an issue when querying and/or fetching from the database using a wildcard character.

For example, neither of the fetch commands below will retrieve anything from the RFOR databank on IHS Magellan

Code: Select all

wfcreate(wf=regionalmacro) q 1960:01  2020:04
dbopen rfor
fetch NR@*.Q
fetch NR@??.Q

However, the following fetch command that replaces "@" with the ? wildcard (and ?? for state abbreviations) will retrieve the total population forecast series for all of the states (e.g. nr@ak.q, which Eviews automatically renames as nr_ak):

Code: Select all

fetch NR???.Q

This behavior seems to have popped up when Eviews 9.5 was released or shortly before. Is this a bug or an intentional change?

Re: Wildcard character when querying IHS Magellan

Posted: Wed Apr 27, 2016 7:34 am
by EViews Jason
A fix is in progress. It should not require an EViews patch since it is being fixed on the Magellan side. We will post when we believe it is fixed.

Re: Wildcard character when querying IHS Magellan

Posted: Thu Jun 09, 2016 10:24 am
by EViews Jason
The Magellan folks have reported that this has been fixed.