IZ47944: CAN'T APPLY TABLE FILTERS IF TABLE NAME CONTAINS A DASH

APAR status

• Closed as program error.

Error description

• Environment:
  
  6.2 (FP2) TEP client
  
  
  Problem Description:
  
  When creating a custom SQL query and using a warehoues table
  name which contains a dash ("TABLE_TEST-D"), a failure will
  occur when trying to apply filters/thresholds.
  
  Detailed Recreation Procedure:
  
  1) If a warehouse table with a dash doesn't currently exist,
  create one (ex. NT_CACHE-D with a column called TEST_INT of
  type integer)
  
  2) Either create or modify a workspace and select properties
  
  3) When assigning a query, create a custom sql query making sure
  to drive it against the table with a dash in the name.
  
  Ex. SELECT max ("TEST_INT") FROM ITMUSER."NT_CACHE-D"
  
  4) Try setting filter/thresholds, save.
  

Local fix

• N/A
  

Problem summary

• When attempting to create a filter or threshold on a view using
  a custom SQL query where the table name contains a dash (ex.
  "TABLE-NAME"), the editor displays the cell in red and will not
  allow the editor window to close.
  

Problem conclusion

• Added a dash as a valid character for a predicate cell.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  
     | interim fix | 6.2.0.3-TIV-ITM-IF0001
  

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

  TEP

• Fixed component ID

  5724C04EP

Applicable component levels

• R620 PSY

     UP