PL23786: NOT FOUND RETURNED INVALID ON AN SQL STM WITH LIKE PREDICATE AGAINST A COLUME THAT CONTAINS A FIELDPROC

APAR status

• Closed as duplicate of another APAR.

Error description

• NOT FOUND IS RETURNED ON AN SQL STATMENT IF THE HOST VAR
  CONTAINS NLS CHARACTERS AND A LIKE PREDICATE IS USED AGAINST
  A COLUME DEFINED WITH FIELDPROC.
  -
  SELECT *
  FROM TABLE
  WHERE COL1 >= :HOST VAR1
  AND   COL2 LIKE :HOST VAR2
  AND   COL3 LIKE :HOST VAR3
  ORDER BY COL1
  -
  THE COLUME IS DEFINED AS
  COL2 CHAR (6) NOT NULL                 FIELDPROC NORSORT,
  -
  IF THE HOST VAR CONTAINS A NLS CHARACTER CONVERTED BY THE FIELD
  PROC ( EXAMPLE  BJ@___ ) WE WILL GET NOT FOUND.
  IF THE HOST VAR DOES NOT CONTAIN A NLS CHARACTER
  ( EXAMPLE BJ____ ) WE WILL GET THE EXPECTED RESULT. (ALSO BJ@XXX
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

•   *** PL23786 IS A DUPLICATE OF PL24929 (UL28701) ***
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels