DB2 FOR LUW / DB2FORLUW / 970 - DB2

You will receive an  SQL1822N error if you meet both of the 
following condition: 
(1)Using rtrim function in  Informix server version 11 
(2)the column to be trimed contains null value 
 
This problem occurs since v91 fixpack9, in which the error 
reported is 
like below: 
SQL1822N  Unexpected error code "-201 (offset 68)" received from 
data source 
   "DATASTORE2". Associated text and tokens are "A syntax error 
has occurred.". 
   SQLSTATE=560BD 
 
 
For example: 
 
create wrapper informix; 
create server DATASTORE2 type informix version 11.0 wrapper 
informix.........; 
create user mapping for user server DATASTORE2............; 
set passthru DATASTORE2; 
create table testtbl (ch char(10)); 
insert into testtbl values('aaa'); 
insert into testtbl values(null); 
set passthru reset; 
create nickname "nick1" for "DATASTORE2"."j15user1"."testtbl"; 
db2 => select ch from "nick1" where rtrim(ch) = 'a' 
 
CH 
---------- 
SQL1822N  Unexpected error code "-201 (offset 68)" received from 
data source 
"DATASTORE2". Associated text and tokens are "A syntax error has 
occurred.". 
SQLSTATE=560BD

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description Above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to FixPack 3 or higher.                              * 
****************************************************************

change the Informix server version from 11 to 10

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V9.7 FixPack 3

not known / see Local fix

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

05.05.2010
12.03.2012
12.03.2012

9.7.FP3