Fixes are available
Closed as program error.
When query with SUBSTR or LIKE predicates are issued against Informix data source, Federation Server might return following error message: SQL1822N Unexpected error code "-202" received from data source "S80UATSOC". Associated text and tokens are "An illegal character has been found in the statement." SQLSTATE=560BD. The problem may happen when all of the following conditions are met: 1. The query contains nicknames from Informix datasource 2. The query has one or both of following predicates: 1) predicate with SUBSTR in a style like: SUBSTR(C1, 1, 1) = '9' 2) predicate with LIKE in a style like: C1 LIKE '9%', which has a '%' 3. The federation database and remote Informix datasource are non-unicode databases, with the same collating sequence. The problem is, in the above scenarios, Federation Server will pad characters to the constants of the SUBSTR or LIKE predicate, then send them to remote Informix server, but these paded characters are considered illegal and cause error in Informix side.
Setting collating_sequence server option to 'N' can block pushdown of predicates with strings, hence avoids the error.
Users affected: Users of the Informix wrapper in the DB2 for LUW Homogeneous Federation Feature or InfoSphere Federation Server Problem description and summary: See error description.
Problem was first fixed in Version 9.5 FixPak 6 (s100805 ). This fix should be applied on Federation Server.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
JR36125 JR36126 IC67930
Fixed component name
Fixed component ID
Applicable component levels
19 September 2010