APAR status
Closed as program error.
Error description
https://www.ibm.com/docs/en/rbd/9.6?topic=access-get-considerati ons-sql details the following: get considerations for SQL If you specify the singleRow option, the SQL SELECT statement stands alone. If you do not specify singleRow, the SQL SELECT becomes a clause in a cursor declaration (an SQL OPEN statement). For more information about the SQL code that EGL generates, see SQL data access. This is incomplete as fundamentally the generation is based on whether the SQLRecord is specified on the applicable get statement. The behavior in relation to COBOL will be expanded within the next documentation update.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * EGL users referencing the documentation * **************************************************************** * PROBLEM DESCRIPTION: * * "get considerations for SQL" documentation was incomplete * * and has now been expanded: * * https://www.ibm.com/docs/en/rbd/9.7?topic=access-get-conside * * rations-sql * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The issue is fixed in 9.7
Temporary fix
Comments
APAR Information
APAR number
PH41554
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
960
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-10-25
Closed date
2022-07-01
Last modified date
2022-09-08
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"960","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
08 September 2022