PH15994: CAN'T GENERATE A DDL FOR A STORED PROCEDURE THAT HAS THE QUERY KEYWORD IN IT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When trying to DDL a stored procedure with "QUERY" keyword, it
  fails
  
  Missing or unexpected SQL-routine-body in native stored
  procedure
  
  ADB2PA: The following statement could not be parsed
  
  Sample failing stored proc
  
  CREATE PROCEDURE AS_TRANSACTIONS_SEARCH_BIBI1
    ()
    LANGUAGE SQL
    NOT DETERMINISTIC
    READS SQL DATA
    CALLED ON NULL INPUT
    DYNAMIC RESULT SETS 1
    DISABLE DEBUG MODE
    PARAMETER CCSID EBCDIC
    QUALIFIER KAS
    PACKAGE OWNER @DB2DBAD
    ASUTIME NO LIMIT
    COMMIT ON RETURN NO
    INHERIT SPECIAL REGISTERS
    NODEFER PREPARE
    CURRENT DATA NO
    DEGREE 1
    DYNAMICRULES BIND
    WITHOUT EXPLAIN
    WITHOUT IMMEDIATE WRITE
    ISOLATION LEVEL UR
    WITH KEEP DYNAMIC
    OPTHINT ''
    RELEASE AT COMMIT
    REOPT NONE
    VALIDATE BIND
    ROUNDING DEC_ROUND_HALF_EVEN
    DECIMAL(15)
    QUERY ACCELERATION ALL
    BUSINESS_TIME SENSITIVE YES
    SYSTEM_TIME SENSITIVE YES
    ARCHIVE SENSITIVE YES
    P1:
    BEGIN
      DECLARE SELECT_STMT VARCHAR( 3000) ;
      SET SELECT_STMT = 'BIBI';
    END P1
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Parser issues an error while processing *
  *                      DDL of a stored procedure with "QUERY   *
  *                      ACCELERATION" keyword.                  *
  ****************************************************************
  Parser fails to process DDL of a stored procedure with "QUERY
  ACCELERATION" keyword. The lack of support of the option caused
  the error.
  
  Missing or unexpected SQL-routine-body in native stored
  procedure
  
  ADB2PA: The following statement could not be parsed :
  [DDL of stored procedure]
  
  Token number = [token_number], Token = QUERY
  
  ACCELERATOR option is also included in this fix.
  

Problem conclusion

• The 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:

  UI66928

Modules/Macros

• ADB2CDC  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP  ADB2MSK  ADB2OVW
  ADB2PA   ADB2RE   ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP
  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADBCCMM  ADBCDTS
  ADBCP    ADBCVC   ADBCVCP  ADBCVCT  ADBCVEY  ADBCVIC  ADBCVOC
  ADBVFC   ADBVFCA  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66928

     UP19/12/25 P F912

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.