PH55610: SB COMMAND ON ALIAS OBJECT IN PACKAGE DEPENDENCIES RESULTS IN DSNT408I SQLCODE = -199,

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For DB2 v13 FL V13R1M503 system, specifying the SB line command
  on an ALIAS (type = A) object row on Package Dependencies at
  Statement Level panel (Panel ADB21KDS), this error may result:
  
  DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FETCH.
  TOKEN IS LIKE * BETWEEN = ^= > >= < <= ^< ^> <> != !< !> AT IN
  ISNULL WAS EXPECTED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The user is issuing SB line command     *
  *                      in panel ADB21KDS on a package that     *
  *                      has stored procedure with an alias      *
  *                      reference and an error occurs.          *
  ****************************************************************
  User is looking at package dependencies at the statement
  level on panel ADB21KDS and then issues a SB line command
  on a dependency that has an alias at the statement level.
  An error occurs with the following message:
  
  DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FETCH.
  TOKEN IS LIKE * BETWEEN AT IN ISNULL WAS EXPECTED
  

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:

  UI94404

Modules/Macros

• ADB21KDS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI94404

     UP23/12/02 P F311

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.