Page 1 of 1

Pulling Data from Oracle

Posted: Fri Dec 08, 2023 9:17 am
by oleviasharbaugh
I'm in the process of updating old programs to include a direct connection to Oracle and have come across a small problem. I'm using the following command structure to pull in the data I need, then unstack it into a format that makes sense:

Code: Select all

pageload(type=odbc, timeout = 900) FilePath\OracleConnection.dsn "SQL code to pull the correct data" @keep * pageunstack(page = Units, namepat=?_*) COMBOFIELD yearmo @ ?*
The issue I encounter is that the data is automatically pulled into a new page in Eviews called "Units". Even if I already have a "Units" page created, it will not put the data into the old page, but rather create a new one named "Units1" since "Units" is already taken. Is there a way to have the data go into a page that already exists using the pageunstack command?

For now, I am using a for loop to copy over the data into the original page, then delete the new page. However, some of the programs I need to update are pulling a lot of data and the process seems rather tedious. I'd love to find a more straightforward way to pull the data into the correct page in the first place.

Thanks in advance for any suggestions!

Re: Pulling Data from Oracle

Posted: Fri Dec 08, 2023 10:06 am
by EViews Gareth
No, pageunstack needs to create a new page each time.

Re: Pulling Data from Oracle

Posted: Fri Dec 08, 2023 10:27 am
by oleviasharbaugh
Okay. So in your opinion, would using a for loop to just copy those variables over to the desired page be the best way to do it?

Re: Pulling Data from Oracle

Posted: Fri Dec 08, 2023 11:03 am
by EViews Gareth
yes.