JR59829: QUERY IN IGC IS RETURNED NO RESULT FOR FILTER CONDITIONS LIKE CONTAINS, CONTAINS ANY WORDS, BEGINS WITH, AND ENDS WITH.

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 issue as described can be reproduced by following these
  steps:
  IIS Launch Pad -> Information Governance Catalog -> Queries:
  - Create a New query
  - Select Asset Type = ETL - Stage Column
  - From the Available Properties, click on Link -> Job or
  Container -> Name
  - In the DISPLAY Displayed Properties, add "Link - Job or
  Container - Name"
  - Click on Run to run the query, this should display all DS
  jobs available
  - In the CRITERIA, add a condition -> "Link - Job or Container
  - Name", then enter a search string that you would expect to
  get for one of the conditions like: Contains, Contains any
  words, Begins with, Ends with, etc, then click on Run - it will
  return no results.
  

Local fix

• N/A
  

Problem summary

• *********************************************
  APAR Users Affected:
  *********************************************
  Users running queries on StageColumns and there were
  restrictions in the query.
  
  *********************************************
  APAR Problem Description:
  *********************************************
  Queries with a restrictions against Stage Columns asset type
  returned no results. It was caused by inappropriate casting
  types in query execution engine. As we improved object (of type
  Stage Column) casting queries return correct results now.
  
  *********************************************
  APAR Recommendation:
  *********************************************
  Apply the fix for JR59829
  
  *********************************************
  

Problem conclusion

• Apply the fix for JR59829
  

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• RB50 PSY

     UP

• RB71 PSY

     UP