PH64778: SQL QUERY DOES NOT WORK WHEN THE IN CLAUSE HAS MORE THAN 2 VALUES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When executing a SQL Query having more than two values in the
  IN clause in DVM Studio, it does not work.
  The same query with one or two values in the IN clause runs
  successfully.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH64778                                 *
  *                      IN clause with more than 2 values does  *
  *                      not work                                *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH64778
  IN clause with more than 2 values does not work
  

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

• AVZCUSPW AVZOBRSQ AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD
  AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOMABR AVZOVSED
  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 UO02095

     UP25/02/19 P F502

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.