[Gretl-devel] Re: ODBC connector
Am 19.02.2020 um 10:19 schrieb atecon:
1) I want to write a open_odbc_connection() function. Unfortunately,
the 'open' command cannot be executed within a function. For its
standard application loading a data set I fully understand the reason.
However, for just opening a ODBC connection by the '--odbc" option, I
don't get rational for this restriction.
Feature request: Allow making use of the open command in case the
--odbc option is passed.
Wanting this functionality sounds very reasonable, but
I'm noticing that
'open .... --odbc' does not seem to be documented in the command reference.
2) While loading data through the 'data' command, e.g. by executing
<data x query="@statement" --odbc>, this command does not seem to work
in case one wants to send a 'statement' -- like "create table" or
"drop table" -- to the database which does not return a series.
Feature request: allow sending a sql-statement which does not return a
series or anything.
Maybe these points imply to add a new command or function. What do you
think?
Hm, at first sight I don't find it compelling that gretl should become a
odbc management tool. The appendix in the guide is called "Data _import_
via ODBC" for a reason I'd say. Why can't you use other tools for that,
for example Python in a foreign block, or shell commands?
thanks
sven