Maximo Wire - The IBM Maximo Help & Discussion Forum
February 08, 2012, 02:36:36 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
  Print  
Author Topic: How to check for integrity Constraint before inserting into business table..?  (Read 610 times)
0 Members and 1 Guest are viewing this topic.
vijet
Jr. Member
**

Karma: 5
Posts: 56



View Profile Email
« on: January 19, 2009, 07:15:44 am »

Hi All,

I am trying to check for integrity of data before inserting into the business table of maximo from the interface table....

I have 2 tables say developer and devuser..
Developerid is unique in developer table and combination of developerid and devuserid is unique in other.

When MEA inserts into the devuser table it has to check if the developerid already exists in the developer table and should insert into devuser only if the developerid is already there in developer table.

I am not able to figure out how i can do this... When MEA inserts the data it gets from the queues so how will i get this data from the queue to check for integrity...?

Please suggest me a way to go about implementing the above...

Regards
Vijet
Logged
vijet
Jr. Member
**

Karma: 5
Posts: 56



View Profile Email
« Reply #1 on: January 19, 2009, 10:44:28 am »

Hi All,

I was able to sort it out....  Grin

There is a setting in the interface tab....

You need to have a relationship between the 2 MBO's.............

Under Integration

1. Select the interface for which you want to check the integrity.
2. In inbound processing rules click new row under MBO processing rules.
3. Give the rule name and the type of check (Ex: Skip)
4. Click add\modify conditions button (You will get a window)
5. Under conditions click new row and below in the XML Field section click new row.
6. select the field which you want to check and set the evaluating condition from the list.
7. In the radio buttons click on MBO
8.  Give the mbo name with which you want to check and the relationship between the two MBOs and select the field of the related MBO
9. Click ok and save..... Thats all... (MEA will do the rest....)

If there is any error occurs during check then it will be displayed in the logs and the xml file of the data which could not be inserted will be in the MEA GLOBAL folder under the error folder......

Hope this info helps others.....

Cheers....
VIJET
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!