DB2 CONNECT / DB2CONNCT / 910 - DB2

A CLI application may receive a CLI0002W "Data Truncated" 
warning message when executing a query against DB2 for z/OS, 
when the expected warning is SQLSTATE=01003 "Null values were 
eliminated from the argument of a column function." 
 
When this warning is returned, DB2 for z/OS updates the 
SQLWARN[1] field in the SQLCA to either an "N" (for 
non-scrollable cursors) or "S" (for scrollable cursors).   The 
DB2 CLI driver does not expect a value for SQLWARN[1], and if it 
does, it makes the assumption that data was truncated. 
 
SQLSTATE=01003 will be returned when the query uses an aggregate 
function like MAX() and the column contains NULL values.

Users Affected:  CLI applications 
Problem Description: 
A CLI application may receive a CLI0002W "Data Truncated" 
warning message when executing a query against DB2 for z/OS, 
when the expected warning is SQLSTATE=01003 "Null values were 
eliminated from the argument of a column function."

On DB2 for z/OS there is a parameter called DISABSCL.  If this 
parameter is set to YES, and the cursor specified is a 
non-scrollable cursor, then DB2 for z/OS will not return "N" 
in SQLWARN[1].  So, setting DISABSCL=YES might workaround the 
issue. 
 
The db2cli.ini keyword IGNOREWARNINGS=1 can be used as well to 
suppress all warnings, including the CLI0002W message.

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Problem was first fixed in Version 9.1 Fix Pack 9

see LOCAL FIX

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

01.09.2009
14.04.2010
16.12.2010

9.1.FP9