DB2 CONNECT / DB2CONNCT / A50 - DB2

If you have an ODBC application that connects to a DB2 server 
through a DB2 Gateway, your SELECT queries may return SQL0100W ( 
(SQL_NO_DATA_FOUND ) after upgrading your DB2 Gateway to DB2 
10.5 FP4 (or later), even if those queries are supposed to 
return data. 
 
Example : 
 
DB2 Client -> DB2 Gateway ( 10.5 FP4 or FP5 ) -> DB2 Server 
 
On the DB2 client : 
 
more test.clp  : 
opt autocommit on 
opt echo on 
opt callerror on 
sqlallocenv 1 
sqlallocconnect 1 1 
sqlsetconnectattrw 1 SQL_ATTR_COMMITONEOF SQL_COMMITONEOF_ON 
SQLDriverConnectW 1 0 "DSN=SAMPLE;uid=user;pwd=password;" -3 255 
SQL_DRIVER_NO_PROMPT 
sqlallocstmt 1 1 
sqlexecdirectw 1 "select 'RESULT' from sysibm.sysdummy1" sql_nts 
sqlfreestmt 1  SQL_CLOSE 
killenv 1 
 
db2cli < test.clp 
.... 
> sqlexecdirectw 1 "select 'RESULT' from sysibm.sysdummy1" 
sql_nts 
SQLExecDirect: rc = 100 (SQL_NO_DATA_FOUND) 
....

**************************************************************** 
* USERS AFFECTED:                                              * 
* ODBC users with DB2 z/OS server                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 FP7 or later                             * 
****************************************************************

add the following parameter in your db2dsdriver.cfg file 
    <parameter name="CommitOnEOF" value="0"/>

The problem was first fixed in DB2 10.5 FP7

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.03.2015
19.01.2016
19.01.2016