PH47793: QUERY RETURNING 0 ROWS WHEN USING A OCCURS FIELD AS A PREDICATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a SELECT Statement VSAM Virtual Table and using an
  ARRAY field as a predicate, it returns zero resultset even
  though the field exists.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH47793                                 *
  *                      Problem with query returning 0 rows     *
  *                      when using a occurs field as a          *
  *                      predicate                               *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH47793
  Problem with query returning 0 rows when using a occurs field
  as a predicate
  

Problem conclusion

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:

Modules/Macros

• AVZCCUHL AVZCDSAM AVZCDSRL AVZCRLSI AVZCSQOP AVZOEXEV AVZOPAEX
  AVZOPMS  AVZOPPA  AVZPB    AVZSIN00 AVZSQ29D AVZSQ29N AVZSQ2BN
  AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI83279

     UP22/11/15 P F211

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.