OA68008: DEFINE WHERE AND LOOKUP DON'T WORK CONSISTENTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DEFINE WHERE and LOOKUP don't work consistently
  

Local fix

• The handling of WHERE clauses in combination with SLFN
  functions, like LOOKUP does not work, especially for SELECT
  clauses.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of zSecure Admin/Audit exploiting      *
  *                 indirect references (lookups) in CARLa       *
  *                 scripts.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: zSecure Admin/Audit might generate      *
  *                      incorrect results and issue a           *
  *                      MSGCKR1142 in cases where record        *
  *                      selection statement (SELECT/EXCLUDE/    *
  *                      EXISTS/MISSING) refers to an indirect   *
  *                      reference (lookup).                     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF provided.                      *
  ****************************************************************
  When an indirect reference (lookup) definition contains a WHERE
  clause, the zSecure Admin/Audit might deliver incorrect results
  and issue a MSGCKR1142 which begins with the text "Duplicate and
  conflicting entry for key=<key> in lookup..." in cases where
  such lookup is used in the record selection statement (SELECT
  EXCLUDE/EXISTS/MISSING).
  

Problem conclusion

• zSecure Admin/Audit has been modified, so that record selection
  referring to indirect references (lookups) defined with a WHERE
  clause is performed properly.
  

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:

  UJ97365

Modules/Macros

• CKAAU    CKRLKUV  GKRAU    GKRLKUV
  

Fix information

• Fixed component name

  ZSEC BASE,ADMIN

• Fixed component ID

  5655T0100

Applicable component levels

• R310 PSY UJ97365

     UP25/06/11 P F506

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.