PH00280: PANEL ADB21 FSEL OUTPUT MAY INCLUDE STORED PROCEDURES IN ADDITION TO USER-DEFINED CAST FUNCTIONS ROUTINETYPE SYSROU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The xSEL function allows customers to specify a WHERE
  clause for the corresponding x function, where x is a function
  on panel ADB21.  The xSEL function thus should not yield a
  larger result set than that produced by the x function.
  
  The FSEL function, however, does not include the required
  ROUTINETYPE='F' in the WHERE clause of its query of
  SYSIBM.SYROUTINES, as the F function does.  As a result, when
  the SELECT statement is executed, the results may include
  functions with ROUTINETYPE = 'P' (stored procedure), in
  addition to the expected user-defined or cast functions
  (ROUTINEYTPE='F').
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When 'FSEL' (which allows you           *
  *                      to specify a WHERE clause when          *
  *                      listing functions) is entered on the    *
  *                      Option line of panel ADB21              *
  *                      'System Catalog', the results may       *
  *                      include stored procedures in addition   *
  *                      to functions.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When 'FSEL' is entered on the Option line of panel ADB21
  'System Catalog', panel ADB21TSE 'Build SQL SELECT Prototype'
  displays the SELECT statement with 'WHERE ?', instead of
  "WHERE ROUTINETYPE='F'". The result set may thus stored
  procedures (with ROUTINETYPE='P'), in addition to the expected
  user-defined or cast functions (with ROUTINETYPE='F').
  

Problem conclusion

• Problem has been resolved.
  

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:

Modules/Macros

•    ADB21    ADB21TSE ADB21TSR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.