JR41821: Information Analyzer client doesn't allow to save a Virtual Table with a free form filter if the expression is too complex.

APAR status

• Closed as program error.

Error description

• Virtual Tables cannot be created which contain "complex" SQL
  statements. The IA Virtual Table free form filter should either
  not filter free form SQL statements or to significantly
  reduce the amount of filtering
  

Local fix

• Fix provided in rollup_RU11_IA_ALL_8502,
  rollup_RU12_IA_ALL_8503, rollup_RU7_IA_ALL_8702,
  rollup_RU1_IA_ALL_9120
  

Problem summary

• Virtual Tables cannot be created which contain "complex" SQL
  statements. Customer wants IA Virtual Table free form filter to
  either not filter free form SQL statements or to significantly
  reduce the amount of filtering.
  

Problem conclusion

• APAR JR41821 was opened for this issue.
  Fix was delivered in 85RP7. Upgrade to Information Analyzer 8.5
  Rollup Patch 7 or 8.5 Fix Pack 3.
  

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 INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• R850 PSY

     UP