Skip to Content
avatar image
Former Member

Sequencing in MDO

Hi Everyone,

Does MDO has any ID property similar to transactionid function in MII that gets incremented after each execution cycle? We are inserting the data in MDO and would like to have one column as ID which contains value such as 1 to refer to first insertion, 2 to refer to 2nd insertion and so on...How can we achieve this using MDOs?

Thanks,

Rajeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 13, 2015 at 04:51 AM

    Thanks for your inputs

    Actually, the sequencing can be implemented by using a persistent variable and using an Assignment block as a counter..

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2015 at 05:36 AM

    Hi Rajeev,

    You have some default columns with an MDO that records insert timestamp. You can make use of it.

    Thanks,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded

    • No Rajeev,

      There is a set of columns that gets created automatically for every MDO created for insertion(the one that doesn't have data source). You would be able to see those in your MDO select query not on MDO object.

      Please find the image below for reference. You can make use of these columns.

      Thanks,

      Swaroop