PI54680: CONVERT COMMAND ABEND S0C4 AT OFFSET X'382' IN MODULE DSQGPRTT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABENDS0C4 in DSQGPRTT when user tries to DISPLAY or CONVERT
  a QMF Prompted Query query that references one or more
  temporal tables that do not exist.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS users who use           *
  *                 Prompted Query.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABENDS0C4 can occur when users use a    *
  *                      query that was created using QMF's      *
  *                      Prompted Query feature and references   *
  *                      temporal tables that do not exist in    *
  *                      the DB2 subsystem in which QMF is       *
  *                      running.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a PQ query references multiple DB2 temporal tables, and
  the last table referenced exists but any one of the earlier
  referenced tables does not exist, QMF incorrectly builds a
  linked list of those tables.  The pointer to the last
  table in the linked list is 00000000.  This will result in an
  ABENDS0C4 during the processing of the query.
  

Problem conclusion

• Code was amended to reject the use of PQ queries that reference
  invalid temporal table names.
  

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:

  UI34359

Modules/Macros

• DSQGPRIL
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB10 PSY UI34359

     UP16/01/13 P F601

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.