Hi all,
At least with latest git version on Ubuntu 18.10, I am experiencing
problems with ODBC. Both of the following queries are pretty standard,
and I've succesfully used the first one before. Stuff also works fine
using the isql client via the terminal.
<QUERY_1>
open dsn=@DSN user=@USER password=@PW --odbc
data klima query="SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc
</QUERY_1>
<ERROR_1>
ERROR: Error executing script: halting
data klima query="SELECT KLIMA FROM
OV_AS_LAB_LUMEN.IFO_DATA" --odbc
</ERROR_1>
The weird thing is that I obtain a new series but which has only zero
values which is wrong.
<TERMINAL_1>
SQLDisconnect(dbc): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_DBC, dbc): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_ENV, OD_env): SQL_SUCCESS
SQL query: 'SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA'
Number of columns = 1
col 1 (KLIMA): data_type SQL_DECIMAL, size 4, digits 1, nullable 2
Number of Rows (from SQLRowCount) = 1886
SQLFreeHandle(SQL_HANDLE_STMT): SQL_SUCCESS
SQLDisconnect: SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_DBC): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_ENV): SQL_SUCCESS
</TERMINAL_1>
Here "sektor" is a string variable.
<QUERY_2>
open dsn=@DSN user=@USER password=@PW --odbc
data sektor query="SELECT SEKTOR FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc
</QUERY_2>
<ERROR_2>
ERROR: Error executing script: halting
data sektor query="SELECT KLIMA FROM
OV_AS_LAB_LUMEN.IFO_DATA" --odbc
</ERROR_2>
Again I get a new series but all values are missings which is also wrong.
<TERMINAL_2>
SQLDisconnect(dbc): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_DBC, dbc): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_ENV, OD_env): SQL_SUCCESS
SQL query: 'SELECT SEKTOR FROM OV_AS_LAB_LUMEN.IFO_DATA'
Number of columns = 1
col 1 (SEKTOR): data_type SQL_VARCHAR, size 20, digits 0, nullable 2
binding data col 1 to strvals[0] (len = 20)
Number of Rows (from SQLRowCount) = 1886
SQLFreeHandle(SQL_HANDLE_STMT): SQL_SUCCESS
SQLDisconnect: SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_DBC): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_ENV): SQL_SUCCESS
</TERMINAL_2>
Any idea what's going on here?
Thanks,
Artur