JR50904: The ORDER BY CLAUSE OF REMDUP STAGE HAS INCORRECT COLUMN ALIASES AFTER APLYING JR50499 PATCH for Job Optimizer

APAR status

• Closed as program error.

Error description

• The error  "Reason: [SQLCODE=42S02][Native=29] ERROR:  relation
  does not exist NZDB.ADMIN.BALOP_3" still occurs after applying
  
  JR50499 patch.
  
  Failed to execute SQL statement: delete from NZDB.ADMIN.TABLE1
  where exists (select 1 from (select BALOP_5.TEN as TEN,
  BALOP_5.CIF as CIF, BALOP_5.CCLO as CCLO ....
   ......
  ((NZDB.ADMIN.TABLE1.CIF = BALOP_6.CIF) and
  (NZDB.ADMIN.TABLE1.CCLO = BALOP_6.CCLO))) .Reason:
  [SQLCODE=42S02][Native=29] ERROR:  relation does not exist
  NZDB.ADMIN.BALOP_3
  

Local fix

Problem summary

• ERROR DESCRIPTION:
  The error  "Reason: [SQLCODE=42S02][Native=29] ERROR:  relation
  does not exist NZDB.ADMIN.BALOP_3" still occurs after applying
  
  JR50499 patch.
  
  Failed to execute SQL statement: delete from NZDB.ADMIN.TABLE1
  where exists (select 1 from (select BALOP_5.TEN as TEN,
  BALOP_5.CIF as CIF, BALOP_5.CCLO as CCLO ....
   ......
  ((NZDB.ADMIN.TABLE1.CIF = BALOP_6.CIF) and
  (NZDB.ADMIN.TABLE1.CCLO = BALOP_6.CCLO))) .Reason:
  [SQLCODE=42S02][Native=29] ERROR:  relation does not exist
  NZDB.ADMIN.BALOP_3
  
  LOCAL FIX:
  None
  

Problem conclusion

• The patch for this APAR is combined with the patch for JR50499
  

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:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R910 PSY

     UP

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP