PK59992: ADD SUBSTRING FUNCTIONALITY WITH NEW CQM UDF (CQMUDF03)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add substring functionality with new CQM UDF (CQMUDF03).  The
  UDF function takes four parameters:
  
  1) the SQLTEXT column name
  2) an integer representing the desired output CCSID
  3) the starting position within the SQLTEXT data
  4) the length of the data to be returned
  
  The UDF converts data stored in the BLOB columns to CLOB output
  transforming the data with Unicode conversion services and this
  conversion is limited by the nature of the CCSID of the data
  being translated.  For example, you cannot convert a DBCS
  character set to a SBCS character set.  Additionally, the CCSID
  definitions must be defined to conversion services.  The UDF
  does not support indirect conversions.
  
  Assuming you have defined the UDF with the name of GET_SUBTEXT
  and a schema name of CQMTOOLS, the following example will return
  a character string that is converted to CCSID 1047 from the
  SQLTEXT column starting in position 1 for a length of 25:
  
    SELECT CQMTOOLS.GET_SUBTEXT(SQLTEXT,1047,1,25) FROM
       CQMTOOLS.CQM22_SUMM_TEXT;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Query Monitor.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Add substring functionality with new    *
  *                      CQM UDF (CQMUDF03).  The UDF function   *
  *                      takes four parameters:                  *
  *                                                              *
  *                      1) the SQLTEXT column name              *
  *                      2) an integer representing the desired  *
  *                         output CCSID                         *
  *                      3) the starting position within the     *
  *                         SQLTEXT data                         *
  *                      4) the length of the data to be         *
  *                         returned.                            *
  *                                                              *
  *                      The UDF converts data stored in the     *
  *                      BLOB columns to CLOB output             *
  *                      transforming the data with Unicode      *
  *                      conversion services and this            *
  *                      conversion is limited by the nature of  *
  *                      the CCSID of the data being translated. *
  *                      For example, you cannot convert a DBCS  *
  *                      character set to a SBCS character set.  *
  *                      Additionally, the CCSID definitions     *
  *                      must be defined to conversion services. *
  *                      The UDF does not support indirect       *
  *                      conversions.                            *
  *                                                              *
  *                      Assuming you have defined the UDF with  *
  *                      the name of GET_SUBTEXT and a schema    *
  *                      name of CQMTOOLS, the following         *
  *                      example will return a character         *
  *                      string that is converted to CCSID       *
  *                      1047 from the SQLTEXT column starting   *
  *                      in position 1 for a length of 25:       *
  *                                                              *
  *                      SELECT CQMTOOLS.GET_SUBTEXT(SQLTEXT,    *
  *                      1047,1,25) FROM CQMTOOLS.CQM22_         *
  *                      SUMM_TEXT;                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address these issues.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF.
  

APAR Information

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

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

  UK40672 UK40673

Modules/Macros

•    CQMDOC   CQMREAD  CQMUDFJ1 CQMUDFJ2 CQMUDFLM
  CQMUDF03
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK40672

     UP08/10/31 P F810

• R221 PSY UK40673

     UP08/10/31 P F810

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.