PH71121: Q Capture should ignore trailing whitespaces in search condition string values search condition string values

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Q Capture should ignore trailing whitespaces in
  search condition string values
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Capture users                         *
  *                 2- Q Capture customers using search          *
  *                 conditions                                   *
  *                 3- Users who want Event Publisher messages   *
  *                 with MQRFH2 header that include a TOPIC.     *
  *                 (message_format='J' for JMS)                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Add DBID/OBID/PSID to ASN7895 msg    *
  *                      2- Q Capture should ignore trailing     *
  *                      whitespaces in search condition string  *
  *                      tokens.                                 *
  *                      3- When using Event Publisher with      *
  *                      message_format='J', Q Capture fails     *
  *                      with MQ_FORMAT_ERROR                    *
  ****************************************************************
  1- Currently there is not enough information to identify the
  table in error when ASN7895 message is issued.
  2- When using a WHERE clause to filter rows, Db2 ignores
  trailing spaces, in both the CHAR/VARCHAR values in the row and
  the string token in the WHERE clause. Q Capture incorrectly
  filters out rows when the search condition contains string
  tokens that contain trailing spaces (Example: WHERE C1 = ' ').
  It should behave as Db2 does and rtrim string token before
  comparing it to row values.
  3- Codepage encoding is wrong for the MQMD part of the MQ
  message.
  

Problem conclusion

• 1- Add DBID/OBID/PSID to ASN7895 msg
  2- Q Capture correctly ignores trailing whitespaces in search
  condition string tokens.
  3- Fixed
  Note: ASNCLP has been updated from v1159 s2605051006.
  Function Level: 1140.103
  

Temporary fix

Comments

APAR Information

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

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

  UO07734 UO07735 UO07736 UO07737

Modules/Macros

• ASN2BASE ASN2DB2C ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC ASNAAPP
  ASNACMD  ASNACMP  ASNADMSP ASNAFET  ASNAISO  ASNAMAN  ASNAPP
  ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR ASNBNDSR ASNBPXB  ASNCAP
  ASNCATM  ASNCCDA  ASNCCDD  ASNCCMD  ASNCCPWK ASNCDA   ASNCDD
  ASNCDINS ASNCLP   ASNCLPAP ASNCLPB  ASNCLPCL ASNCLPCM ASNCLPCO
  ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA ASNCLPRM ASNCMPLD ASNCSCZ
  ASNCTLZD ASNDADK  ASNDB2CN ASNDB2SQ ASNDBCON ASNDEDE  ASNDONE
  ASNENUP  ASNENUS  ASNESES  ASNFIFI  ASNFRFR  ASNITIT  ASNJAJP
  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA ASNMON   ASNMONIT ASNMPROC
  ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE ASNPTBR  ASNQ1021 ASNQ1140
  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBNDE
  ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP  ASNQCCDA ASNQCCDD
  ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP  ASNQEXRP ASNQFALL ASNQJ001
  ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQP2PA ASNQP2PI
  ASNQPROF ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT ASNRBASE
  ASNRURU  ASNS1021 ASNSFALL ASNSQLCZ ASNSVSE  ASNTDIFF ASNTDSP
  ASNTDSQL ASNTRC   ASNUOW   ASNV1021 ASNV1140 ASNVCD   ASNVMON
  ASNVREOR ASNVSQL  ASNZHCN  ASNZHTW  ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UO07734

     UP26/05/12 I 1000

• RB34 PSY UP

     A

• RB35 PSY UP

     A

• RB36 PSY UP

     A

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.