Korinne Adler

I forgot that XMLSERVICE adds all that in the xml output anyway, lol. FYI, the XML output you shared is 12M of _just_ XML metadata since it looks like all...

If that's the case, you could use dou/enddo to limit the amount of data returned. Assuming you never really need to return all 99,999 possible rows, this might be a...

> I saw the dou in the documentation but could not wrap my head around how it works . Yeah, it's confusing like so much of XMLSERVICE. > On that...

Can you please provide a [trace](https://github.com/IBM/node-odbc?tab=readme-ov-file#debugging) of the problem?

Ok. From the trace, I see that for vk_1, this is described by the driver as a NUMERIC(9, 2). We bind this as SQL_C_CHAR with a buffer of length 11...

One potential fix would be to comment out these lines and rebuild: https://github.com/IBM/node-odbc/blob/3694c4d3d749d8c642c6994ac85eddfcf6de8630/src/odbc_connection.cpp#L3382-L3389 This would cause the data to be bound as a `double`, obviating the need to call `atof`...

Thanks, glad it worked! I'm gonna re-open to track making the change here.

``` 319 info run [email protected] install node_modules/odbc node-pre-gyp install --fallback-to-build 326 info run [email protected] install { code: 127, signal: null } ... 348 error node: A file or directory in...

Generally QSH is not recommended for open source/PASE stuff. I wonder if you were hitting a threading issue? https://ibmi-oss-docs.readthedocs.io/en/latest/troubleshooting/README.html#commands-are-failing-in-qsh SSH (or possibly QP2TERM) is gonna be a better environment to...

Can't you set an encoding on the connection? ```python import pyodbc conn = pyodbc.connect('DSN=...', encoding='utf-32le') # or utf-32be if you're big endian ``` Then pyodbc will encode the connection string...