I have a notes-database which uses ODBC to retrive data-records fromDB2 on AS/400. I use ODBCconnection and ODBCResultSet to retrieve data.
This works just fine when the user execute the connection from an action-button in the application, but when I schedule the agent, the values returned contains “false”.
The number of records retrieved is correct.
Subject: Scheduled ODBC agent return “false” as value - OK when run from action-button
Found a solution.
In the server-document I had spesified that 5 agents could run at the same time. This caused the server to allocate to much memory, so the agent truncated the column-header name in the result-set.
When number of agents was set to 4 insted, the agent worked as normal.
If you want mor details, feel free to send me an e-mail on mailto:jtmarkus@frisurf.no.