Please consider registering

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
How to delete Child object via MIF
I want to delete Child objects for a given Parent object via MIF Enterprise Service (using interface table)
May 19, 2014
4:47 pm
New Member
Forum Posts: 2
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

For Maximo

Say I have within Maximo a PARENT and CHILD table/object (one to many type of relationship).  How can I configure the MIF Enterprise Service using interface tables so that I can send deletes of some of the CHILD table records but not all of them and still keep the PARENT table record?

This doesn’t seem to me to be obvious when reading the Integration Guide for IBM Maximo Asset Management 7.1.

Is there a special way to populate the interface data table or the interface queue table (MXIN_INTER_TRANS)?  Or, does this require coding an inbound processing class for the object structure?

May 22, 2014
9:29 am
New Member
Forum Posts: 2
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Okay, I’ll answer my own question; hopefully, others looking for this answer will find this thread.

According to the IBM Maximo Asset Management 7.1 Integration Guide, if you are using a parent-child type of object structure, one way to go about “deleting” child objects on an inbound interface based using interface tables is to specify a Replace action (in MXIN_INTER_TRANS) and in the IFACE table, make sure to insert records for all children objects that you want to keep (and do not insert records for the child objects you are targeting for deletion).

If you have further questions, or want some clarification, please reply to this thread and I’ll try to answer to the best of my abilities.


Hope this helps.

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14366

Moderators: 0

Admins: 4

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4295

Newest Members:

Megan Morgan, Devendra Verma, stephen stephens, maxexpertise Hilal, Jeroen van Proosdij, Neeraja N

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0, bpaik: 0