PH24345: CQD APRIL 2020 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• - A fully qualified key with a WHERE on IMS-Direct table is
  using IMS-Direct instead of DBCTL
  - SMF data disappears when Select contains ADD ORDER BY
  - SMF View of a View not using __DSN and always switching to
  the DEFAULT DSN in the Global Variable
  - SQL With clause only returns last column
  - Abend 0C4 in queries using WITH clause as an optional prefix
  for SELECT
  - INSERT after UNION inserts wrong values in seq file
  - Resultset ordered incorrectly for Adabas SQL with ORDER BY
  - SQL Query fired against IMS Root segment abends with '0C'4
  for IMS-DIRECT type
  - SQLEngine Date and Time function DAYOFYEAR returns 0
  - IMS query returns Incorrect output for sub select
  - ABEND 0C4 ACCESSING ADABAS WHEN USING SELECT IN
  - SQL MAX function for ADABAS Date & Timestamp return Invalid
  ADABAS time found in result set column 1
  - Add z15 ARCH-13 support for all Metal-C modules
  - SELECT COUNT() gives SRB SYSTEM ABEND X'0C3' AT
  sdevsqce/AVZSQLCN
  - Support for SMF 102 IFCID 0199
  - SELECT RUNSTATS on large table gets s0C3 abend
  - Utilize IMS Dynamic Allocation Library for IMS Direct access
  - SELECT DISTINCT on a DB2 Virtual table that has RUNSTATS
  gives incorrect results
  - Unable to create virtual table from an IMS logically related
  virtual segment
  - ADABAS SQL Update into a field with NC null option doesn't
  update field
  - Select with CASE returns incorrect precision
  - SELECT query sets Type to VARCHAR and leaves out trailing
  spaces
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A fully qualified key with a WHERE on   *
  *                      IMS-Direct table is using IMS-Direct    *
  *                      instead of DBCTL                        *
  *                                                              *
  *                      SMF data disappears when Select         *
  *                      contains ADD ORDER BY                   *
  *                                                              *
  *                      SMF View of a View not using __DSN and  *
  *                      always switching to the DEFAULT DSN in  *
  *                      the Global Variable                     *
  *                                                              *
  *                      SQL With clause only returns last       *
  *                      column                                  *
  *                                                              *
  *                      Abend 0C4 in queries using WITH clause  *
  *                      as an optional prefix for SELECT        *
  *                                                              *
  *                      INSERT after UNION inserts wrong        *
  *                      values in seq file                      *
  *                                                              *
  *                      Resultset ordered incorrectly for       *
  *                      Adabas SQL with ORDER BY                *
  *                                                              *
  *                      SQL Query fired against IMS Root        *
  *                      segment abends with '0C'4 for           *
  *                      IMS-DIRECT type                         *
  *                                                              *
  *                      SQLEngine Date and Time function        *
  *                      DAYOFYEAR returns 0                     *
  *                                                              *
  *                      IMS query returns Incorrect output for  *
  *                      sub select                              *
  *                                                              *
  *                      ABEND 0C4 ACCESSING ADABAS WHEN USING   *
  *                      SELECT IN                               *
  *                                                              *
  *                      SQL MAX function for ADABAS Date        *
  *                       & Timestamp return Invalid ADABAS      *
  *                      time found in result set column 1       *
  *                                                              *
  *                      Add z15 ARCH-13 support for all         *
  *                      Metal-C modules                         *
  *                                                              *
  *                      SELECT COUNT() gives SRB SYSTEM         *
  *                      ABEND X'0C3' AT sdevsqce/AVZSQLCN       *
  *                                                              *
  *                      Support for SMF 102 IFCID 0199          *
  *                                                              *
  *                      SELECT RUNSTATS on large table gets     *
  *                      s0C3 abend                              *
  *                                                              *
  *                      Utilize IMS Dynamic Allocation Library  *
  *                      for IMS Direct access                   *
  *                                                              *
  *                      SELECT DISTINCT on a DB2 Virtual table  *
  *                      that has RUNSTATS gives incorrect       *
  *                      results                                 *
  *                                                              *
  *                      Unable to create virtual table from an  *
  *                      IMS logically related virtual segment   *
  *                                                              *
  *                      ADABAS SQL Update into a field with     *
  *                      NC null option doesn't update field     *
  *                                                              *
  *                      Select with CASE returns incorrect      *
  *                      precision                               *
  *                                                              *
  *                                                              *
  *                      SELECT query sets Type to VARCHAR and   *
  *                      leaves out trailing spaces              *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  A fully qualified key with a WHERE on IMS-Direct table is using
  IMS-Direct instead of DBCTL
  
  SMF data disappears when Select contains ADD ORDER BY
  
  SMF View of a View not using __DSN and always switching to
   the DEFAULT DSN in the Global Variable
  
  SQL With clause only returns last column
  
  Abend 0C4 in queries using WITH clause as an optional prefix
   for SELECT
  
  INSERT after UNION inserts wrong values in seq file
  
  Resultset ordered incorrectly for Adabas SQL with ORDER BY
  
  SQL Query fired against IMS Root segment abends with '0C'4 for
  IMS-DIRECT type
  
  SQLEngine Date and Time function DAYOFYEAR returns 0
  
  IMS query returns Incorrect output for sub select
  
  ABEND 0C4 ACCESSING ADABAS WHEN USING SELECT IN
  
  SQL MAX function for ADABAS Date & Timestamp return Invalid
   ADABAS time found in result set column 1
  
  Add z15 ARCH-13 support for all Metal-C modules
  
  SELECT COUNT() gives SRB SYSTEM ABEND X'0C3' AT
  sdevsqce/AVZSQLCN
  
  Support for SMF 102 IFCID 0199
  
  SELECT RUNSTATS on large table gets s0C3 abend
  
  Utilize IMS Dynamic Allocation Library for IMS Direct
   access
  
  SELECT DISTINCT on a DB2 Virtual table that has RUNSTATS
  gives incorrect results
  
  Unable to create virtual table from an IMS logically
   related virtual segment
  
  ADABAS SQL Update into a field with NC null option doesn't
  update field
  
  Select with CASE returns incorrect precision
  
  SELECT query sets Type to VARCHAR and leaves out
  trailing spaces
  

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:

  UI69741

Modules/Macros

• CQD$W54E CQD$W54M CQD$X540 CQD$X541 CQD$X542 CQDCDSAL CQDCDSOP
  CQDCMTCL CQDCRDBD CQDCS1HD CQDCSQOP CQDCTVOP CQDIMPDS CQDMCLUP
  CQDMDTBL CQDO319D CQDO319N CQDO31AD CQDO31AN CQDO31BD CQDO31BN
  CQDO31CD CQDO31CN CQDO31DD CQDO31DN CQDO649D CQDO649N CQDO64AD
  CQDO64AN CQDO64BD CQDO64BN CQDO64CD CQDO64CN CQDO64DD CQDO64DN
  CQDOBRSR CQDOBRTV CQDODF9D CQDODF9N CQDODFAD CQDODFAN CQDODFBD
  CQDODFBN CQDODFCD CQDODFCN CQDODFDD CQDODFDN CQDODT9N CQDODTAN
  CQDODTBN CQDODTCN CQDODTDN CQDOINAS CQDOKY9D CQDOKY9N CQDOKYAD
  CQDOKYAN CQDOKYBD CQDOKYBN CQDOKYCD CQDOKYCN CQDOKYDD CQDOKYDN
  CQDOLI9D CQDOLI9N CQDOLIAD CQDOLIAN CQDOLIBD CQDOLIBN CQDOLICD
  CQDOLICN CQDOLIDD CQDOLIDN CQDOPMS  CQDOPPA  CQDPB    CQDSBMIG
  CQDSEFCK CQDSQ29D CQDSQ29N CQDSQ2AD CQDSQ2AN CQDSQ2BD CQDSQ2BN
  CQDSQ2CD CQDSQ2CN CQDSQ2DD CQDSQ2DN CQDSQL9D CQDSQL9N CQDSQLAD
  CQDSQLAN CQDSQLBD CQDSQLBN CQDSQLCD CQDSQLCN CQDSQLDD CQDSQLDN
  CQDWSCLP CQDWSMFL
  

Fix information

• Fixed component name

  QMF DATA SERVIC

• Fixed component ID

  566872103

Applicable component levels

• RC10 PSY UI69741

     UP20/05/30 P F005

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.