PH22025: UNION ALL IN A VIRTUAL VIEW GIVES A "MISPLACED SELECT STATEMENT"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using a SQL UNION of three data sources works as follows:
  -----
  select id, name from db2_staff
  union all
  select staffvs_key_id id, staffvs_data_name name from dvmc_staff
  union all
  select id, name from ord2_q_staff
  -----
  When attempting to create a Virtual View, the Validate button
  fails with:
  "Misplaced SELECT keyword found."
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: UNION ALL in virtual view give          *
  *                      "misplaced SELECT Statement"            *
  ****************************************************************
  UNION ALL in virtual view give "misplaced
  SELECT Statement"
  

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

• AVZ$461E AVZ$461M AVZ$462E AVZ$462M AVZ$IA40 AVZ$IA42 AVZ$IAL1
  AVZ$IAO1 AVZ$K610 AVZ$K611 AVZ$K612 AVZ$K613 AVZ$K614 AVZ$K615
  AVZ$K616 AVZ$K617 AVZ$K620 AVZ$K621 AVZ$K622 AVZ$K623 AVZ$K624
  AVZ$KE32 AVZ$KE33 AVZ$KFE1 AVZ$ME20 AVZ$MEP0 AVZ$N830 AVZ$N850
  AVZ$N860 AVZ$N870 AVZ$N880 AVZCCAPR AVZCDSPS AVZCDSTZ AVZCMQIO
  AVZCSPTB AVZCSQMM AVZMFMIG AVZOIO31 AVZOPPA  AVZOPRUT AVZPB
  AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN AVZSQ2BD AVZSQ2BN AVZSQ2CD
  AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLAD AVZSQLAN
  AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN AVZSQLDD AVZSQLDN AVZWSIMP
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI68240

     UP20/03/10 P F003

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.