IBM Support

Setting field values to null from interface tables or flat files data sources

Flashes (Alerts)

Abstract base services fix pack implements a usability enhancement that provides Maximo Integration Framework (I-F) with functionality that supports setting field values to null from Interface Tables or Flat Files data sources


This Fix Pack will provide support for setting field values to null from interface tables and flat files. Prior to base services fix pack, the component that converts flat data (i.e. data from a flat file or interface table) to XML does not support setting a field value to null by providing an empty XML tag in the message.

This functional enhancement updates the referred component to recognize the input field value of ~NULL~ from the data source field and perform processing logic that will result in that field be updated to a null value in Maximo. With this IF change any field in a flat file or any non-numeric/non-date field in an interface table may be set to ~NULL~ and this will result in the corresponding business object field being set to null.

To do this, the inbound processing logic will create the appropriate tags with no value in the flat to XML conversion which will allow the IF to set the MBO field to null during processing.

Processing Considerations

There are 2 exceptions where this approach will not support the nulling of fields:

      a) processing numeric fields from interface tables
      b) processing date fields from interface tables.
In both cases, the database will not allow the value ~NULL~ to be set to the fields. These fields will continue to require processing rules/Java to set null to the field values.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"MEA: Generic","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
25 September 2022