JR43692: CA fails for Flatfile VT which has a column name having spaces in VT where clause.

APAR status

• Closed as program error.

Error description

• Column Analysis fails for Virtual table when a columns name
  contains space
  
  Steps:-
  1. Create a flat file with spaces in the column names
  2. Importe the metadata into project
  3. Create a VT with a simple where clause condition
  4. Run thnalysis
  Result :- CA ran fine but does not display any records
  

Local fix

Problem summary

• If a VT which is created from a Flat File  has a  column having
  spaces in name and that column is used in VT where clause, CA
  results is not available .CA does run successfully but open CA
  result does not show any result.
  The fix is available in 85 RP10.
  

Problem conclusion

• Fix is available in 85 RP10 and 87 RP3
  

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

• R870 PSY

     UP