Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cannot retrieve diagnostic information after SELECT SUM() with NULL values

5 views
Skip to first unread message

sebflaesch

unread,
Jul 5, 2010, 10:40:54 AM7/5/10
to s...@4js.com
Hi,

Using SYBASE ASE 15.5 developer edition, with Sybase ODBC driver
(libsybdrvodb.so) on Linux 32b:

Normally when you execute a SELECT SUM(col) FROM table where col
contains NULLs, you should get a warning:

01003: Warning – null value eliminated in set function.

SQLExecute() returns SQL_SUCCESS_WITH_INFO as expected, but when I try
to get the warning details with SQLGetDiagRec(), that function returns
100 (SQL_NO_DATA) ...

With all other ODBC drivers I have used for now, I get a diagnostic
record...

Seb

0 new messages