PK94049: DSQ40393 GDDM ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using QMF to call a stored procedure the customer gets:
  DSQ40393 GDDM error ADM0209 E FIELD IDENTIFIER -16843010 IS
  NEGATIVE. Severity 8.  Function ASFCUR. *** CMD=DELETE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 deleting  *
  *                 global variables created when running a      *
  *                 stored procedure.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users deleting global variables from    *
  *                      the SHOW GLOBALS panel that were        *
  *                      created by the QMF stored procedure     *
  *                      processor can experience a "MSGDSQ40393 *
  *                      GDDM error ADM0209 E FIELD IDENTIFIER   *
  *                      -16843010 IS NEGATIVE. Severity 8.      *
  *                      Function ASFCUR. *** CMD=DELETE" along  *
  *                      with MSGDSQ20005. Additional error      *
  *                      symptoms may be an ABEND0C4 in DSQEWNDD *
  *                      at offset x'240C'.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following scenerio illustrates the problem:
  -Run the query: CALL SYSPROC.DSNWZP (&P1)
  -Enter a ' ' (blank) on the QMF variable prompt panel.
  -After the stored procedure completes, enter the
   SHOW GLOBALS command and page to the bottom of the global
   variable list. Put cursor on the variable P1 field value and
   press PF11 DELETE.
  -The errors happen.
  The problem may be seen when running any stored procedure
  that creates a new global variable.  When the last variable
  created by the stored procedure processor is deleted via
  the SHOW GLOBALS panel, the problem occurs.
  

Problem conclusion

• Module DSQDCALL has been fixed to create stored procedure global
  variables correctly so that they appear in alphabetical order at
  the beginning of the global variable list before QMF defined
  global variables.
  

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:

  UK49474 UK49475

Modules/Macros

• DSQDCALL
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK49474

     UP09/08/22 P F908

• R910 PSY UK49475

     UP09/08/22 P F908

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.