PM52787: SYNTAX ERROR 40 IN ADB21KSQ SYSNNNNN: INCORRECT CALL TO ROUTINE - LINE NNN: DB2LENGTH = C2D(SUBSTR(STMT,1,4))+4

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' SQ line command fails
  with a message:
  Syntax error 40 in ADB21KSQ SYSnnnnn: Incorrect call to routine
  - Line nnn: db2length = C2D(Substr(stmt,1,4))+4
  when attempting to show the SQL in a package.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'SQ - SQL in package'       *
  *                 line command on panel ADB21K 'Packages'.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      'SQ' line command fails with a message: *
  *                                                              *
  *                      Syntax error 40 in ADB21KSQ             *
  *                      SYSnnnnn:                               *
  *                      Incorrect call to routine               *
  *                      - Line nnn: db2length =                 *
  *                      C2D(Substr(stmt,1,4))+4                 *
  *                                                              *
  *                      when attempting to show the SQL in a    *
  *                      package.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program can not extract the SQL from the package bound
  remotely from an OPEN system.
  

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:

  UK75571 UK75572

Modules/Macros

•    ADB21KSQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75571

     UP12/01/21 P F201

• R720 PSY UK75572

     UP12/01/21 P F201

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.