IV89016: QUERIES WITH ASSOCIATED OBJECTS WILL SHOW 0 FOR NUMERIC FIELDS WHEN THE PRIMARY RECORD HAS NO ASSOCIATED RECORD.

APAR status

• Closed as fixed if next.

Error description

• Queries with associated objects will show 0 for numeric fields
  when the primary record has no associated record.
  
  If you have a report that uses an association to a second
  object and run a report, the associated record wills how 0 even
  if the TRIRIGAweb.properties says do not show 0 for null values.
  

Local fix

Problem summary

• SHOW_ZEROS_IN_NUMBER fields is for use for Form based views.
  Will update queries to adhear to this as well.
  

Problem conclusion

• Fixed an issue where empty numeric fields in Query Reports
  would show a '0' value even though the TRIRIGAWEB property
  SHOW_ZEROS_IN_NUMBER_FIELDS was set to not show zeros and show
  blanks instead.  This is targeted to the 2h2016 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

•    None
  999
  

Fix information

Applicable component levels