PK95891: UNABLE TO CALL FULLY QUALIFIED USER DEFINED FUNCTIONS FROM QMF PROMPTED QUERY UTILITY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In QMF Prompted Query, users cannot use the Expression panel
  to create a query that contains a fully qualified User Defined
  Function name.  Users receive the message DSQ8540:
  Column name starting with hlq.xxxxxx(yyyyy) is invalid.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V810 and V910 who       *
  *                 use QMF Prompted Query to call User          *
  *                 Defined Functions.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: QMF Prompted Query will not fully       *
  *                      qualify a User Defined Function         *
  *                      name when the user tries to add the     *
  *                      UDF name in the Column Expression       *
  *                      panel.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Prompted Query is not designed to build SQL with User Defined
  Function names, nor does QMF document that UDFs can be used
  in PQ panels.  It was only by serendipity that singly
  qualified UDFs have been successfully processed in the past.
  However, since DB2 will execute SQL that contains fully
  qualified UDFs, Prompted Query should be enhanced to do
  likewise.
  

Problem conclusion

• Prompted Query logic has been updated to process 2-part names
  in the Expression panel.
  

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:

  UK51488 UK51489

Modules/Macros

• DSQGPRTK
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK51488

     UP09/10/29 P F910

• R910 PSY UK51489

     UP09/10/29 P F910

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.