Re: [Gretl-users] exporting data via odbc
Am 19.05.2011 08:37, schrieb RENIER Mélanie:
Dear all,
I am currently using Gretl with Oracle.
I retrieve data from the server to gretl via an SQL, then I make predictions in gretl.
I would like to know if it is possible to next export the database with the prediction
results directly on the server? Such as other users have access to the new database.
If yes, how to achieve this?
This is difficult to answer without knowing the setup you're working
with. For example if you don't have write permissions on the server,
obviously it's not possible.
But it's not in the manual, so I suppose it's not directly supported.
(But maybe it is, and it's just undocumented, I don't know.) However, in
any case you can call other command-line tools from within a gretl
script, check out the "shell" keyword in the online help. So in
principle it should be possible to specify in your script the login to
the database server via the shell and then insert/send the data. Of
course, there may be security issues if for example you have to include
your database server password in the script.
cheers,
sven