Hi all,
for the first time I am working with gretl's ODBC connector. So far it
seems to work fine for standard queries using the Exasol data base on
linux. However, I stumbled over to 2 issues:
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.
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?
Thanks,
Artur