IV95184: REPORT MANAGER - WHERE USED DOESN'T WORK WITH A SINGLE QUOTE IN THE NAME

APAR status

• Closed as fixed if next.

Error description

• If you add a single quote to a query name and click Where Used,
  it
  errors. This is suspect is due to the SQL generated, as it would
  require an extra single quote to pass the string correctly. If
  you add
  another single quote, to 'escape' the character, it will work
  correctly. This is an amendment to the SQL query that is
  generated when
  clicking where used. Additional logic is required, where it
  searches
  for a single quote and then if it finds one, it adds it to the
  SQL
  generated.
  
  This PMR cannot suggest we don't use single quotes, as the OOTB
  application would require changes to be made.
  

Local fix

• N/A
  

Problem summary

• Need to update SQL call to allow for single quote in parameter.
  

Problem conclusion

• Issue is resolved where report "Where Used" tab throws an
  exception if the report has single quote (') in the name.
  This is targeted to the 1h2107 release.
  

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:

Modules/Macros

• 999
  

Fix information

Applicable component levels

• R352 PSY

     UP