ODBCResultSet not returning any results

HCL Domino Domino Forum
1

I set up an ODBCConnection class and was able to connect to a DB2 database. I was able to see the tables using the ListTables method and the fields using the ListFields method. The connection worked.

When I tried to write a SELECT statement, the ODBCResultSet does not return anything. This is the statement that I used:

“SELECT * FROM SALES_ORD WHERE SAP_SALES_ORD_NUM = ‘0051968827’”. Is this an access to DB2 issue?

2

Subject: ODBCResultSet not returning any results

Hi Aline,

Try a more simple SQL statement to begin with:

SELECT * FROM SALES_ORD

and see how you get on, if that doesn’t work recheck your table name, are you sure it isn’t SALES_ORDERS, or similar.

Thanks

Jim