PH44228: LOAD 4 ROWS INSTEAD 1 ROW WHEN RECORD_ID = 1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• "SELECT AVI1, AVI2, AVI3, AVI5, PRATI2, PRATI4, PRATI8,
  MISHPAHA2, MISHPAHA4, BIRTH_DATE, BIRTH_TIME, RECORD_ID,
  CHILD_KEY, BASE_KEY FROM DBAVI4 WHERE RECORD_ID =1 "
  When this SQL is executed from the Data Studio, the result
  is 1 row BUT when we run the LOAD utility with this SQL in
  the HLVCSR cursor, the Loader loads 4 rows instead of 1 row.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH44228                                 *
  *                      Load 4 rows instead 1 row when          *
  *                       RECORD_ID = 1                          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH44228
  Load 4 rows instead 1 row when RECORD_ID = 1
  

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:

  UI79583

Modules/Macros

• 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 UI79583

     UP22/03/05 P F203

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.