DB2 FOR LUW / DB2FORLUW / B10 - DB2

db2batch returning CLI0112E message in some situations when NULL 
is being passed on run-time. 
 
To recreate the problem: 
 
Create a table : 
create table test1 (AIRRES_URID BIGINT); 
 
Create and save one SQL in a file : 
$ cat test1.sql 
SELECT AIRRES_URID from test1 where AIRRES_URID = 
COALESCE(?,AIRRES_URID); 
 
Create  a parameter input file : 
$ cat param1.txt 
Null 
 
Then  run db2batch in following way, 
$ db2batch -d sample -f test1.sql -m param1.txt -i complete -iso 
UR -o p 5 o 5 r -1 -r db2batch.out 
** CLI error in executing the SQL statement: 
(-99999): [IBM][CLI Driver] CLI0112E  Error in assignment. 
SQLSTATE=22005

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               * 
****************************************************************

Avoid  passing the parameter "Null" during run-time.  Instead, 
put the same  inside the query before running.

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in DB2 11.1 Mod 2 Fix Pack 2

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.03.2017
23.06.2017
23.06.2017