JR37546: RULES CREATED IN 811 THAT ARE AGAINST A VIRTUAL TABLE THAT HAS A WHERE CLAUSE WHICH CONTAINS QUOTED STRINGS

APAR status

• Closed as fixed if next.

Error description

• "Rules created in 811 that are against a Virtual table that has
  a Where clause which contains quoted strings, wherein the quote
  is escaped by a \ character, fail with a SQL error when they are
  executed in 812. Workaround is to edit the Where clause and
  remove the \ character."
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Information Analyzer 8.1.2 users that upgraded from an 8.1.1
  system.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Rules created in Information Analyzer 8.1.1 that are against a
  Virtual table that has a Where clause which contains quoted
  strings, wherein the quote is escaped by a \ character, fail
  with a SQL error when they are executed in Information Analyzer
  8.1.2.
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.1.2 Fix Pack 4, or 8.5 Fix
  Pack 1, or 8.7.
  ****************************************************************
  

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:

Fix information

Applicable component levels

• R812 PSN

     UP