A fix is available
APAR status
Closed as program error.
Error description
If SingleRow Option is used in SQL Statement and the result set of the statement contains more than 1 row, the execution of the statement should result in an SQLCODE -811 exception which is as expected for COBOL generated programs. Its observed that the SingleRow is effectively ignored running a Java generated program or via the EGL debugger the SQLCODE -811 is not be thrown and processing continues.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * RBD Users * **************************************************************** * PROBLEM DESCRIPTION: * * As described in the abstract of the APAR information * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fixed.
Temporary fix
Comments
APAR Information
APAR number
PH18441
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-10-23
Closed date
2020-08-19
Last modified date
2020-08-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RATL BUS DEV
Fixed component ID
5724S5000
Applicable component levels
R950 PSY
UP
[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]
Document Information
Modified date:
16 September 2021