DB2 - Problem description
Problem IT29206 | Status: Closed |
SQLSETCONNECTATTRW() WITH SQL_ATTR_SESSION_GLOBAL_VAR ATTRIBUTEIS NOT WORKING AS EXPECTED | |
product: | |
DB2 CONNECT / DB2CONNCT / B10 - DB2 | |
Problem description: | |
When application has SQLSetConnectAttrW() API call with SQL_ATTR_SESSION_GLOBAL_VAR attribute, it is working as designed. Client is not sending the attribute list to server and resulting in unexpected error. memcpy(membuf, "SQL_COMPAT='NPS'", 17); membuf[17] = ' '; toWideChar(membuf, szAttribBuf); sql_rc = SQLSetConnectAttrW(hdbc, SQL_ATTR_SESSION_GLOBAL_VAR, szAttribBuf, SQL_NTS); When application calls like this, client is not sending the SQL_COMPAT='NPS' to server. In DRDA trace we see empty set statement flowing to server: DDM Format: d0 SEND(AR) OBJDSS - Object Data Stream Structure LL: 23 CORR: 0003 CHAINED: y CONT ON ERR: n SAME CORR FOR NEXT DSS: n NM: SQLSTT - SQL Statement LL: 17 CP: 2414 DATA: (ASCII) (EBCDIC) 0000000007534554 20203D20FF .....SET = . ............. DDM Format: d0 SEND(AR) RQSDSS - Request Data Stream Structure LL: 78 CORR: 0004 CHAINED: y CONT ON ERR: n SAME CORR FOR NEXT DSS: y | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 CLI/ODBC Unicode API users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 11.1.4.5 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.05.2019 23.02.2020 23.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |