PH35130: NEW GEN STORED PROCEDURE ADBGDDL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides new stored procedure ADBGDDL, which can be
  used as a simple callable interface to get the DDL for a single
  object in the Db2 catalog.
  
  Notice: The authorization switching feature of Db2
  Administration Tool is deprecated. For more information, see
  https://ibm.biz/Bdf2Sf
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides a                    *
  *                      simple callable interface               *
  *                      to get the DDL for a single             *
  *                      object in the Db2 catalog.              *
  ****************************************************************
  A new stored procedure ADBGDDL is delivered.
  
  ADBGDDL provides a simple interface that performs the
  following actions:
  
  -Sets default values for around 80 GEN parameters
  -Sets up the request to generate DDL
  -Verifies that request is only for a single object
  -Sets a return code and a message for the caller
  
  The stored procedure has following parameters:
  
  TYPE     - Object type. Supported types are:
     AL,DB,DT,FU,IX,SG,SP,SQ,QA,SY,TB,TG,TS,VW,GV,RO,TC,MK,PM
  QUAL    - Object qualifier.
     Required for objects that can be qualified.
     Otherwise, this parameter is invalid.
  NAME     - Object name. Required.
  VERSION - Version of the object.
     Optional for functions, procedures, and triggers.
     Otherwise, this parameter is invalid.
  PARM      - Optional.
     Specify RPT=Y for the GEN report. The default is no report.
  
  On return from call:
  
  RC         - Return code
  MESSAGE - Message that explains what happened
  (success or errors)
  C_SQL      - Result set.
               The generated DDL. Empty if an error occurred
  C_RPT      - Optional result set.
               The GEN report if PARM RPT=Y was specified
  
  To call the procedure:
  
  CALL ADBGDDL(type, qual, name, version, rc, message, parm)
  
  A sample job to create a REST service for this interface
  can be found in member ADBSERV in the SADBSAMP library.
  

Problem conclusion

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:

  UI74702

Modules/Macros

• ADB2CDC  ADB2DEP  ADB2RE   ADB2REE  ADB2REG  ADB2REH  ADB2REM
  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY  ADB2REZ
  ADB2RS   ADB2RSD  ADBBIND  ADBGDDL  ADBSERV  ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74702

     UP21/04/05 P F104

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.