PH27459: IDAA (HLV) SQL UNION QUERIES NOT WORKING WITH SMF VIRTUAL VIEWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• We are using the IDAA HLV (Advanced Loader) product to load data
  from SMF datasets into IDAA. We are trying to use a SELECT
  statement with UNION to load the data from all 4 datasets into
  IDAA. There are two problems with this:
  1. If the first dataset doesn't have any rows, it does not
  continue on to the next dataset. Instead it loads 0 rows and
  stops.
  2. If I remove the first select statement that had 0 rows and
  just union the 3 datasets that have data, the job receives a
  S0C3. Again no rows are loaded.
  3. If I break the job up so that it actually has 4 load steps
  it works. The first step will select from dataset 1 and load 0
  rows (it actually said it loaded 10 rows but this isn't true,
  so something must not be getting cleared out), the second step
  will select from dataset 2 and load the rows, the third step
  will load from dataset 3 and the load the rows, and finally the
  4th step will select from the dataset 4 and load the rows.
  Why is the UNION behaving this way so that I'm forced to load
  in four different steps? I do believe the syntax is correct
  because I have another job where I'm using the union and it
  works.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: IDAA (HLV) SQL Union queries with       *
  *                      sub-table joins not working with SMF    *
  *                      Virtual Views                           *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  IDAA (HLV) SQL Union queries with sub-table joins not working
  with SMF Virtual Views
  

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

• HLV$3D0E HLV$3D0M HLV$410E HLV$410M HLV$420E HLV$420M HLV$JD00
  HLV$K100 HLV$K200 HLVCINWK HLVCSVCL HLVOBRID HLVOIDCL HLVOINAS
  HLVOINIM HLVOLI9D HLVOLI9N HLVOLIAD HLVOLIAN HLVOLIBD HLVOLIBN
  HLVOLICD HLVOLICN HLVOLIDD HLVOLIDN HLVOPAGN HLVPB    HLVSQ29D
  HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN
  HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N HLVSQLAD HLVSQLAN HLVSQLBD
  HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD HLVSQLDN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI72760

     UP20/11/28 P F011

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.