A fix is available
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 number
PH17170
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-09-20
Closed date
2019-12-11
Last modified date
2020-01-03
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
03 January 2020