PH41554: INCOMPLETE DOCUMENTATION ENTRY CONCERNING SQL SINGLEROW OPTION

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 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