JR60260: PARSING DB VIEW FAILS WHEN "WHERE CASE" CLAUSE IS USED.

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• The IGC Lineage SQL parser fails for views containing SQL for
  DB2 with "WHERE CASE" clause.
  

Local fix

• N/A
  

Problem summary

• *********************************************
  APAR Users Affected:
  *********************************************
  Users using Lineage SQL parser for views containing SQL for DB2
  with "WHERE CASE" clause
  
  *********************************************
  APAR Problem Description:
  *********************************************
  InfoSphere Information Governance Catalog is unable to create
  lineage between a job and a table when WHERE clause has CASE.
  
  For example, the parser fails for SQL statements that have the
  following structure:
  
  SELECT p1, p2, ... FROM db.schema WHERE CASE WHEN ...
  
  *********************************************
  APAR Recommendation:
  *********************************************
  Apply the fix for JR60260
  
  *********************************************
  

Problem conclusion

• Apply the fix for JR60260
  

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

• RB71 PSY

     UP