Hi,
I'm having some trouble getting data into gretl through ODBC. I have a fairly large sql statement, so I'm importing it from a file. When I run the data command I get an error and it halts. Here's the command script:
nulldata 160
setobs 5 2001:1 --time-series
open dsn=guestCalgary user=####### password=##### --odbc
string QRY1 = readfile("C:/gretl/maxbufftemp.txt")
data maxbufftemp obs-format-"%d" @QRY1 --odbc
gives me this error:
gretl version 1.8.7
Current session: 2010-02-02 14:34
? nulldata 160
periodicity: 1, maxobs: 160,
observations range: 1-160
? setobs 5 2001:1 --time-series
Full data range: 2001 - 2160 (n = 160)
? open dsn=guestCalgary user=##### password=#### --odbc
Connected to ODBC data source 'guestCalgary'
? string QRY1 = readfile("C:/gretl/maxbufftemp.txt")
Replaced string QRY1
? data maxbufftemp obs-format-"%d" @QRY1 --odbc
Error executing script: halting
> data maxbufftemp obs-format-"%d" @QRY1 --odbc
I have been able to get data from the db with simple queries, so I was wondering, how do I get gretl to tell me what is stored in QRY1? I've tried print, but I can't get it to work and I think that would be the obvious place to start (verifying that my sql call got imported properly). next, I think I might be messing up the obs-format portion of the call. The output from the big sql query is 2 columns, 1 8 digit identifier and 1 number with 2 decimal places.
Also, are there any plans to implement more robust ODBC support? It would be great to be able to import multiple variables at once.
Thanks,
Chris