PH17170: USERS PASSING NULL VALUES WHEN CALLING STORED PROCEDURES MAY GETUNPREDICTABLE RESULTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A user ran the following query from the QMF for TSO SQL query
  panel:
  CALL SYSPROC.DSNACCOX (NULL,NULL,
  NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,30,
  NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
  ,NULL,NULL,NULL
  ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,
  ' ',0,' ',0,0,0)
  
  When DSQEC_SP_RS_NUM was set to 1 to return the first result
  set, the
  user unexpectedly got a blank report.
  When DSQEC_SP_RS_NUM was set to 2 to return the second result
  set, the
  user received errors:
  DSQ17504 The query did not run.  Press the HELP key for more
  information.
  User saw an SQL code -504 with query message THE CURSOR NAME
  CRSR1 IS NOT DEFINED.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.1, V11.2 and V12.1  *
  *                 users.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: A user ran the following query from the *
  *                      QMF for TSO SQL query panel:            *
  *                      *                                       *
  *                      CALL SYSPROC.DSNACCOX (NULL,NULL,       *
  *                      NULL,NULL,NULL,NULL,NULL,NULL,NULL,     *
  *                      NULL,NULL,30,                           *
  *                      NULL,NULL,NULL,NULL,NULL,NULL,NULL,     *
  *                      NULL,NULL,NULL,NULL,NULL,NULL,NULL,     *
  *                      NULL,NULL                               *
  *                      ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,    *
  *                      NULL,NULL,NULL,NULL,NULL,15,            *
  *                      ' ',0,' ',0,0,0)                        *
  *                      *                                       *
  *                      When DSQEC_SP_RS_NUM was set to 1 to    *
  *                      return the first result set, the        *
  *                      user unexpectedly got a blank report.   *
  *                      When DSQEC_SP_RS_NUM was set to 2 to    *
  *                      return the second result set, the       *
  *                      user received errors:                   *
  *                      DSQ17504 The query did not run.  Press  *
  *                      the HELP key for more information.      *
  *                      User saw an SQL code -504 with query    *
  *                      message THE CURSOR NAME CRSR1 IS NOT    *
  *                      DEFINED.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF was not properly setting the null indicator for CHAR and
  VARCHAR stored procedure parameters.This code has been fixed and
  now the null indicator is set correctly.
  

Problem conclusion

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:

  UI66958 UI66959 UI66960

Modules/Macros

•    DSQDCPAR DSQHPSQM DSQHPSQS DSQIPSQM DSQIPSQS
  DSQJPSQM DSQJPSQS
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB10 PSY UI66958

     UP19/12/13 P F912

• RB20 PSY UI66959

     UP19/12/13 P F912

• RC10 PSY UI66960

     UP19/12/13 P F912

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.