PH04050: ADMIN TOOL STORED PROCEDURES GRANTOR SQLCODE -199 SQLCODEN199 ILLEGAL USE OF KEYWORD T

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If 'O' (Stored Procedures) is selected on panel ADB21, with
  a Grantor specified, a SQLCODE -199 / SQLCODEN199 error may
  occur:
      SQLCODE : -199                           DSNTIAR CODE :  0
   DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD T.
  TOKEN SELECTIVITY
            AND OR HAVING GROUP INTERSECT ORDER FETCH EXCEPT WAS
  EXPECTED
   DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = 2  0  0  -1  211  506 SQL DIAGNOSTIC
  INFORMATION
   DSNT416I SQLERRD    = X'00000002'  X'00000000'  X'00000000'
  X'FFFFFFFF'
            X'000000D3'  X'000001FA' SQL DIAGNOSTIC INFORMATION
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE=-199 while issuing Option 'O'   *
  *                      and specifying "grantor" on panel       *
  *                      ADB21.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Selecting option 'O' - Stored procedures from panel ADB21,
  while also specifying a grantor in the "Grantor" field,
  may result in an SQLCODE=-199 error such as the following:
  
    SQLCODE : -199 DSNTIAR CODE : 0
  
   DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF
   KEYWORD T. TOKEN SELECTIVITY AND OR HAVING
   GROUP INTERSECT ORDER FETCH EXCEPT WAS EXPECTED
   DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
  

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:

  UI60411 UI60412

Modules/Macros

•    ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI60411

     UP18/12/25 P F812

• RC10 PSY UI60412

     UP18/12/25 P F812

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.