How to get DB Sequence value in Maximo Code?

[j_4jamshaid]

My ticket table's ticketID is value from some sequence. when i create a ticket using MEA Webservice its asks me to enter TicketID. and if i enter an id that is already in the table, my request updates that record. I want to add a new record every time, I guess i would need a sequence for this ticketID. Now how can i use sequence Using maximo Api? Or can i configure this field in maximo to get value automatically from a sequence?

There is another field ticketUID which is autogenerated. and it works fine if no ticketUID is entered.

@Jamshaid..

[amdisuk]

You would do an add(); on the Mboset. This will set up the defaults for you including all unique id's.

So first you getMboSet("TICKET");

Al

[j_4jamshaid]

well may be ur right. But i need to do it with MEA webservices.

[g000fy]

I know this is an old forum but based on the fact there is very little doco about this stuff thought I would post the answer I found.  The ticket table which stores service requests, incidents, complaints etc does not have an autokey on ticketid.  Maximo is not expecting you to add data to the table directly.  Instead you should be using the views that correlate to each class in the ticket table.  For example the SR (Service request) view is the one you should base your integration object on.  If you look in database configuration for the SR view you will see that ticketid has autokey on it.  This means you do not need to send the ticketid element in your XML.

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]